| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Cell Info
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
For the last numerical value, try...
=LOOKUP(9.99999999999999E+307,F1:F53) Hope this helps! In article , "Ed Davis" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
The sell that I put this formula in stays blank.
Thanks for your help though. "Domenic" wrote in message ... For the last numerical value, try... =LOOKUP(9.99999999999999E+307,F1:F53) Hope this helps! In article , "Ed Davis" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
I am saying that the formula cannot return nothing, either you will get an
error or you will get a number. Nothing is impossible. If your values are text numbers you will get #N/A. To me it sounds as though you have changed the formula somehow and I don't see what formulas in every other row has anything to do with this? -- Regards, Peo Sjoblom "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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
The formulas return a zero. And I had zeros turned off so that is why I saw
nothing. The actual number is a zero. "Peo Sjoblom" wrote in message ... I am saying that the formula cannot return nothing, either you will get an error or you will get a number. Nothing is impossible. If your values are text numbers you will get #N/A. To me it sounds as though you have changed the formula somehow and I don't see what formulas in every other row has anything to do with this? -- Regards, Peo Sjoblom "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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Last Cell Info
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 |
|
#12
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 |
| Reply |
| 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) | |||
Linear Mode
