Final entry in array

[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.

 

[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.

Forgot to say TIA. Sorry, stressed.

Esra

 

[Ashish Mathur]

Hi,

Try this

=LOOKUP(TRUE,ISNUMBER(1/B2:B170),B2:B170)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[T. Valko]

Try this:

=LOOKUP(1E100,B2:B170)

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

 

[Jacob Skaria]

Try
=LOOKUP(10^10,B2:B170)

If this post helps click Yes

 

[Esradekan]

Try
=LOOKUP(10^10,B2:B170)

If this post helps click Yes
---------------
Jacob Skaria





- Show quoted text -

Perfect, thanks so much

Esra