|
|
Returning multiple cells by
bmcgill
I would like to look at cells A1, A2, A3, A4
If the value of C1=A1 then it displays in separate cells the data from Cells
D1 thru D5, if C1=A2 displays D6...
|
|
1 |
110 |
|
|
Calculating towards a target number by
Mary
Dear Excel Expert,
I am trying to figure out a formula for a prison length. I have a set
sentence length which is a number of months (format 00.0), for...
|
August 7th, 2008 08:33 PM
by Mary
|
2 |
85 |
|
|
Formula for x & y calculation by
K. Carter
I need help building a formula to calculate both the "x" and "y" values for
the following equation:
x + y = 90
2.15x + 2.4y = 202.35
The solution would be x...
|
|
5 |
117 |
|
|
|
|
1 |
105 |
|
|
If Function With A Time by
Donna
Hello all.
I need help with an if function that will result in No Delay if Total Time
is less than or equal to 2:30 (two hours, thirty minutes). My total...
|
August 7th, 2008 06:49 PM
by Donna
|
5 |
87 |
|
|
|
|
3 |
97 |
|
|
Excel Worksheet Password Protection by
Christina
I have seen in here that someone has asked the question on how to unprotect a
worksheet when the password has been lost or forgotten. The answer given is...
|
|
1 |
96 |
|
|
Subtotal Function is Inconsistent by
TKS_Mark
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal only
counts...
|
|
4 |
87 |
|
|
Excel 3-D Reference by
FirstVette52
I need help with aq 3-D reference error (REF#):
='Sheet1:Sheet5'!B2
Thanks for the help
--
FirstVette52
|
|
3 |
80 |
|
|
Keeping linked sheets relative... help! by
Gaijintendo
I am linking to external sheets but as soon as I enter
SheetName!A1
it resolves it to something like
='Macintosh:Users:MyName:Desktop:SheetName'!A1
Which is...
|
August 7th, 2008 05:38 PM
by Spiky
|
2 |
95 |
|
|
|
August 7th, 2008 05:35 PM
by Pierre
|
0 |
101 |
|
|
Add different values that equal 1 on a row by
Add sum of different values
I am trying to add how many seat hours per equipment type each person has.
Which formula should I use? I've tried several and I get errors.
Example:
Crane...
|
|
2 |
85 |
|
|
automatically show modified date? by
Tacrier
When I save changes to my current worksheet, is it possible have a formula in
A2 to display today's date (based on the condition that changes were saved to...
|
August 7th, 2008 04:52 PM
by Tacrier
|
2 |
91 |
|
|
Address of last nonzero value by
Wigi
Hans,
here are some formulas for last cell:
http://www.mvps.org/dmcritchie/excel/lastcell.htm
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
|
August 7th, 2008 04:30 PM
by Wigi
|
0 |
92 |
|
|
|
August 7th, 2008 04:18 PM
by cprao
|
3 |
112 |
|
|
look for missing element by
SteveDB1
morning all,
I have two worksheets. One worksheet is a comprehensive listing of all my
components ( it's called sheet A), and the second is a summary of the...
|
|
1 |
71 |
|
|
VLOOKUP by
lindle101
I am trying to do a vlookup and when I check my calculation steps it says
that 'the cell currently being evaluated contains a constant'. I am not sure
about...
|
|
5 |
67 |
|
|
|
|
0 |
87 |
|
|
|
August 7th, 2008 03:18 PM
by M Kan
|
1 |
144 |
|
|
|
|
5 |
90 |