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?
Assuming your values / numbers are in the range A1:A99
=LOOKUP(2;1/ISNUMBER(A1:A99);A1:A99)
Brilliant! Works perfectly. Thanks very much,