Prev: Background or Header picture should cover entire A4 sheet when pri
Next: disable sounds when saving
From: L. Howard Kittle on 18 Jan 2010 14:31
Hi Greg,

Here's another that seems to do what you want.

=OFFSET(F1,COUNTA(F:F)-2,0)

HTH
Regards,
Howard

"Greg" <Greg(a)discussions.microsoft.com> wrote in message
news:1D19B16E-D1BC-4CF3-83A3-6CD261076EE2(a)microsoft.com...
> Hi everyone.
>
> My question has to do with the 2nd to last cell with data in a column. To
> get the last data, I am using "=LOOKUP(10^100,A2:D2)" but how can I get
> the
> data from the cell right above that?
>
> For instance, my data looks like this (multiple tabs for different
> entities):
>
> # of Accounts 1/1/10 45
> $ of Accounts 1/1/10 6300
> # of Accounts 1/2/10 23
> $ of Accounts 1/2/10 1550
>
> So, I want my totals page to show the last 2 entries (# and $).
>
> TIA, any help would be wonderful,
>
> Thanks,
>
> Greg


First  |  Prev  | 
Pages: 1 2
Prev: Background or Header picture should cover entire A4 sheet when pri
Next: disable sounds when saving