|
|
|
|
1 |
147 |
|
|
|
|
2 |
161 |
|
|
|
|
6 |
352 |
|
|
AVERAGE of row gives no result by
cells are formatted as text?
-----Original Message-----
This problem MUST have a really simple answer; I just
don't know what it
is...
When I attempt to...
( 1 2)
|
|
12 |
365 |
|
|
Return last value in a range. by
My range is from A1:A20. The range could have a possible
of 20 numbers, some number may be exactly the same.
Numbers will be entered starting at A1. I am...
|
|
2 |
184 |
|
|
Need simple macro by
Hi All
In Excel 2002
Column A cells 1 to 20 has data in them, Column B1 has data in it,
I would like to have a macro that would copy the data from B1 to all...
|
|
3 |
110 |
|
|
Help by
I am trying to program a worksheet to make the cells turn
red when the row exceeds a $2,500 amount, but it has to be
able to do it after a a specific date like...
|
|
1 |
101 |
|
|
|
July 18th, 2004 03:08 AM
by
|
0 |
252 |
|
|
Excel formula giving #Value! error by
I have a spreadsheet that has cells calculated from other
workbooks. Some cells are updated while others give me an
error of #Value!. The error goes away...
|
|
9 |
153 |
|
|
creating a list from an existing list by
hi!
is there a formula that can create a list from an existing
list for some specific creteria. so kind of an iteration.
so say in one sheet i have list with...
|
March 17th, 2004 02:00 PM
by
|
4 |
205 |
|
|
Compare a cell to a range of cells by
Could someone help me?
What I need is to compare one cell with 35 other static
cells. If the data in the main cell is the same as any of
the other cells it...
|
February 17th, 2004 09:43 AM
by
|
2 |
578 |
|
|
|
November 17th, 2003 02:39 AM
by Scottie
|
5 |
139 |
|
|
Number formatting by
Can anyone tell me how to enter 25 and have it appear in
the cell as 25,000,000? I have only been able to get it
to go out to 25,000 (using a custom fomatting...
|
|
2 |
97 |
|
|
|
|
9 |
387 |
|
|
absolute refernces - range of cells by
I am trying to find an easy way to turn a range of cells
from relative references to absolute references without
going into each cell and hitting F4. Any...
|
December 1st, 2003 08:57 PM
by
|
2 |
175 |
|
|
finding the date in a sheet by
First, Name your data range B2:H5202 as DATA
Then, insert the formula =Today() in an unused cell and
name that cell TODAY
Switch to VBA and insert a module...
|
|
1 |
166 |
|
|
Formula to combine cells (A challenge!) by
Hi,
tried my best to find the answer through the HELP menu and
the knowlege base...but unsucessfull.
I have an expense tracking Excel file, with worksheets...
|
|
4 |
112 |
|
|
error by
Can you tell me what program that was written for? The
one with the #AND#?
Thanks,
CJ
|
|
1 |
102 |
|
|
Calculating next due date by
Hi!
You can try:
=IF(A139,lastphysicaldate+730,lastphysicaldate+1095)
where A1 is the age. (730 and 1095 are two and three years
in days, respectively....
|
|
1 |
338 |
|
|
excel workbook acting weird by
I have an excel workbook that I converted from text. When
I create formula in a cell (A1*2) it just displays the
formula and not the result. I checked the...
|
September 16th, 2004 03:10 PM
by
|
6 |
281 |