CALC: asking CALC to find the bottom most number in a column

English
#1

I have a formula in CALC that needs the bottom-most number in a column for its result. How do I make CALC find that number?

#2

Assuming your values / numbers are in the range A1:A99

=LOOKUP(2;1/ISNUMBER(A1:A99);A1:A99)
#3

Brilliant! Works perfectly. Thanks very much,

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.