|
|
Macro by
Shane
How do I save a macro to a floppy disk so that I may copy
the macro to another computer?
|
|
1 |
294 |
|
|
|
September 17th, 2003 12:46 AM
by Daniel.M
|
2 |
640 |
|
|
Solving for Coefficients of a polynomial by
Dan Mertens
Is there a function in Excel that can return the
coefficients of a polynomial from a set of X values and a
set of Y values? I know you can get a trendline...
|
|
1 |
341 |
|
|
ROUND function or custom format by
Lucy
i'm trying to round to the nearest 100th eg 1436 to 1400,
or 1475 to 1500. i would like to use the custom since if
we use ROUND, we don't have the numbers yet...
|
|
1 |
429 |
|
|
"Sumif"or "if" ...followup question by
Peter
Thanx, Paul, that worked! But I have another question. If
I get a "NO" and enter that in the RSVP column, can I get
the "balance due" to blank...
|
September 16th, 2003 11:24 PM
by James S
|
1 |
332 |
|
|
|
September 16th, 2003 11:12 PM
by s-o-s
|
3 |
588 |
|
|
Order form by
Jamie
I'm creating an order form and I want to automatically
copy information from a database that is on another sheet
in the workbok.
After I enter the Item number...
|
|
1 |
574 |
|
|
drop down by
anita
Does anyone know how to create a drop-down menu in Excel?
For example in Cell A1 I want there to be a list that I
can choose from.
|
|
2 |
390 |
|
|
cell references by
Sandi
does anyone know how to enter a formula to link two pages
when the cell reference always increases by 7 rows.
Right now I have to type the formula in each...
|
September 16th, 2003 10:28 PM
by GB
|
4 |
721 |
|
|
average function by
Rod
When I use the average function like this =AVERAGE(B3:C3),
I get a #DIV/0! error.
B3 C3
(0.6 1.6
Any ideas?
|
September 16th, 2003 10:09 PM
by Rod
|
2 |
472 |
|
|
"If" or "sumif" by
Peter
I am holding a function where if the person comes alone,
the price is $300, but if he brings his wife, the price is
$400. I am collecting deposits, and will...
|
September 16th, 2003 10:06 PM
by Ken L
|
4 |
311 |
|
|
worksheet protection/macro by
wally
Hi,
I have windows xp, home edition. After protecting a worksheet, which
contains formulas, I would like to run a macro to copy and paste the
text only of the...
|
September 16th, 2003 09:50 PM
by wally
|
3 |
314 |
|
|
Average function by
Jeff Kimbell
When I use the average function over a range of cells that
includes a cell with "#VALUE!", the function returns
with "#VALUE!". The description of the average...
|
|
2 |
512 |
|
|
|
|
2 |
293 |
|
|
average f(x) by
briank
Any ideas why this won't work?
=average(ADDRESS(4,26):address(4,33))
|
|
2 |
343 |
|
|
match formula by
donny
I want to create a match formula, I want the formula to
look in column A AND B where numeric values are placed and
look in cells j1 AND J3 because i have a...
|
|
3 |
271 |
|
|
lotus 2.4 macro by
Joe Silvers
The following is an example of a simple macro I used in
Lotus 123.
{goto}E3~
'{?}{D}'{?}{D}'{?}~
{GOTO}C8~'{?}~
Once invoked, the cursor goes to cell E3,...
|
|
1 |
304 |
|
|
Exposant by
garnote
Hi all,
I have X values in Range("A2":A42")
I write x^2, 1-x^2, x^3-2*x^2+12,
e^x, sin(x) ... in B1 (Format: Text)
and use this macro for obtain graphic...
|
September 16th, 2003 08:57 PM
by garnote
|
1 |
303 |
|
|
Excel formulas by
D A Brook
Is it possible for data from several sheets in a workbook
to be brought forward to a collection sheet by selecting
the other sheets from a reference (a list of...
|
|
1 |
305 |
|
|
Sorting by cell or text format by
Does anyone know of a way to sort a list by the cell
format or by the text format? I have a very long list
where the 'good' cells have been colored in yellow....
|
|
1 |
654 |