Prev: display answers to a questionnaire in a chart
Next: tab names are wrong when printing custom footers (using [&tab] )
From: Keith on 2 Jun 2010 07:47
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 2 Jun 2010 07:59
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.
>
 | 
Pages: 1
Prev: display answers to a questionnaire in a chart
Next: tab names are wrong when printing custom footers (using [&tab] )