Thread: Final entry in array
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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.

Reply With QuoteReply With Quote