Final entry in array

  • Thread starter Thread starter Esradekan
  • Start date Start date
E

Esradekan

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.
 
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.
Click to expand...

Forgot to say TIA. Sorry, stressed.

Esra
 
Try this:

=LOOKUP(1E100,B2:B170)

That will return the *last* numeric value from the range.
 
Back
Top