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. > |