How to get a value of data from the last rows of a table

[Eddie]

How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?

 

[Max]

In Sheet2,
you could use something like this in A1:
=LOOKUP(2,1/(Sheet1!D2100<>""),Sheet1!D2100)
to extract the last row value in Sheet1's col D

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Don Guillett]

try this simple where 9999 is larger than any number possible in col d
=lookup(9999,Sheet1!d:d)

 

[Max]

In Sheet2,
you could use something like this in A1:
=LOOKUP(2,1/(Sheet1!D2100<>""),Sheet1!D2100)
to extract the last row value in Sheet1's col D

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Shane Devenshire]

Hi,

assuming you are looking for the item in column D:

Last Number: =LOOKUP(9^9,D)
Last Text enry: =LOOKUP(REPT("z",255),D)
Last Non-blank cell: =LOOKUP(2,1/(B:B<>""),B:B)