| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Final entry in array
If I have an array (B2:B170), what formula do I need to get the final
figure in the list reading from top to bottom? It could be cell 125, or cell 37, it will vary. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Final entry in array
On Nov 17, 4:41*pm, Esradekan wrote:
If I have an array (B2:B170), what formula do I need to get the final figure in the list reading from top to bottom? *It could be cell 125, or cell 37, it will vary. Forgot to say TIA. Sorry, stressed. Esra |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Final entry in array
Hi,
Try this =LOOKUP(TRUE,ISNUMBER(1/B2:B170),B2:B170) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Esradekan" wrote in message ... If I have an array (B2:B170), what formula do I need to get the final figure in the list reading from top to bottom? It could be cell 125, or cell 37, it will vary. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Final entry in array
Try this:
=LOOKUP(1E100,B2:B170) That will return the *last* numeric value from the range. -- Biff Microsoft Excel MVP "Esradekan" wrote in message ... If I have an array (B2:B170), what formula do I need to get the final figure in the list reading from top to bottom? It could be cell 125, or cell 37, it will vary. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Final entry in array
Try
=LOOKUP(10^10,B2:B170) If this post helps click Yes --------------- Jacob Skaria "Esradekan" wrote: If I have an array (B2:B170), what formula do I need to get the final figure in the list reading from top to bottom? It could be cell 125, or cell 37, it will vary. . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Final entry in array
On Nov 17, 7:58*pm, Jacob Skaria
wrote: Try =LOOKUP(10^10,B2:B170) If this post helps click Yes --------------- Jacob Skaria "Esradekan" wrote: If I have an array (B2:B170), what formula do I need to get the final figure in the list reading from top to bottom? *It could be cell 125, or cell 37, it will vary. .- Hide quoted text - - Show quoted text - Perfect, thanks so much Esra (^-^)< |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the cell reference for the next occurrance of entry in array | Excel Worksheet Functions | |||
| i want to count how many times an entry occurs in an array | Excel Worksheet Functions | |||
| final return! | Excel Worksheet Functions | |||
| Final day of month | Excel Worksheet Functions | |||
| Average of an array of entries, minus the lowest entry | Excel Worksheet Functions | |||
Hybrid Mode
