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
(^-^)<
|