| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding most recently entered number within a column
Hi,
Does anyone know how to find the most recently entered number within a column and apply to a calculation? I have a spreadsheet that has an extra row added every week, so the most recently added figures are not in the same cells for the formula. Another way would be to find the lowest visual number (as opposed to lowest numerically) within a column. Hope this makes sense! Thanks for any help, Matt. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding most recently entered number within a column
Your question is not as clear as I would like. Are you looking for the value
in the last filled cell in a particular column? If so, try this formula... =LOOKUP(2,1/(A1:A65535<""),A:A) where you would change all the A's to whatever column designation you want to work in. -- Rick (MVP - Excel) "The Stoat" wrote in message ... Hi, Does anyone know how to find the most recently entered number within a column and apply to a calculation? I have a spreadsheet that has an extra row added every week, so the most recently added figures are not in the same cells for the formula. Another way would be to find the lowest visual number (as opposed to lowest numerically) within a column. Hope this makes sense! Thanks for any help, Matt. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding most recently entered number within a column
In other words, you want to return the *last* number entered in a vertical
list? Try this: =LOOKUP(1E100,A:A) That will return the *last* numeric value entered in cloumn A. -- Biff Microsoft Excel MVP "The Stoat" wrote in message ... Hi, Does anyone know how to find the most recently entered number within a column and apply to a calculation? I have a spreadsheet that has an extra row added every week, so the most recently added figures are not in the same cells for the formula. Another way would be to find the lowest visual number (as opposed to lowest numerically) within a column. Hope this makes sense! Thanks for any help, Matt. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding most recently entered number within a column
Hi,
You really should show us the formula you currently have. But in lue of that =YourFormula(LOOKUP(9^9,A:A)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "The Stoat" wrote: Hi, Does anyone know how to find the most recently entered number within a column and apply to a calculation? I have a spreadsheet that has an extra row added every week, so the most recently added figures are not in the same cells for the formula. Another way would be to find the lowest visual number (as opposed to lowest numerically) within a column. Hope this makes sense! Thanks for any help, Matt. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE | Excel Worksheet Functions | |||
| FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA | Excel Worksheet Functions | |||
| Finding replicate data in a column accidentally entered | Excel Worksheet Functions | |||
| Number is not entered twice in a column or row | Excel Discussion (Misc queries) | |||
| Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
Hybrid Mode
