| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Cell Info
That worked thank you very much.
"Peo Sjoblom" wrote in message ... If indeed you have a zero in the last cell it will return that, try this instead =LOOKUP(2,1/(F1:F53<0),F1:F53) -- Regards, Peo Sjoblom "Ed Davis" wrote in message ... I just realized that the formula = 0 unless something is in another cell. Is there a way to just look for a number other than 0? "Ed Davis" wrote in message ... There are numbers between in cells f11 through f17. When I change the lookup to f1-f17 I do get the number I am looking for that is in row 17. But leaving the lookup as it is shows me nothing. Remember there are formula's in almost every other row. "Peo Sjoblom" wrote in message ... That's impossible, it will return either #N/A or the last numerical value (if there are no numbers) -- Regards, Peo Sjoblom "Ed Davis" wrote in message ... The cell I put this formula in stays blank. Thanks for you help though. "Peo Sjoblom" wrote in message ... Try =LOOKUP(99^99,F1:F53) -- Regards, Peo Sjoblom "Ed Davis" wrote in message ... I have a column lets call it F that has 53 rows. Numbers go into the cell after something is entered in another column so it is a formula. I want to use the last number in that F column. It may be in any row from 1 through 53. Is there a way to get that number. Thanks in advance Ed Davis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
| how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) | |||
Threaded Mode
