| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
