From: Keith on
I have a column listing numbers in worksheet B. I'm looking for a formula
to place in worksheet A that will list the bottom number listed in that
worksheet B column.

Any help would be much appreciated.

From: Jacob Skaria on
Try the below..to retieve the last number

=LOOKUP(10^10,Sheet2!A:A)

--
Jacob (MVP - Excel)


"Keith" wrote:

> I have a column listing numbers in worksheet B. I'm looking for a formula
> to place in worksheet A that will list the bottom number listed in that
> worksheet B column.
>
> Any help would be much appreciated.
>