OFFSET question

[RTB]

Hello,

I'm using a function from Excel 2000 formulas (Walkenbach)

nameate
refer: OFFSET(sheet1!$A$2,0,0,counta(sheet1!$A:$A)-1)
name:Sales
refer: OFFSET(sheet1!$B$2,0,0,counta(sheet2!$B:$B)-1)

a1=date
b1=sales
a2=jan 04
b2=2
etc.

How do I:
1. Reverse this function so that the latest entry is always at the top i.e. B2?

Thanks for any help.

RTB

 

[Jason Morin]

For date:

=OFFSET(Sheet1!A1,COUNTA(Sheet1!A:A)-1,)

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Just as an alternative approach which works also if you have blank
cells in between. Try:
=LOOKUP(9.99999999E307,A1:A10000)

if you want to get a date or numeric value