How do i make a formula reference the last entry of a column

K

Knightrider

Hello I am entering data on a sheet each day and analyzing it on a separate
sheet. Many of the formulas i use need to reference the newest entries. Can
anyone tell me the function you use so that the formula automatically uses
the last entry in a column (so that all i need to do is key in the data each
day.
 
P

PC

Look at the OFFSET function. The row offset would be a COUNT or COUNTA of
the entire column for which you wish to find the last entry. This of course
requires that there are no blank rows in the data.

PC
 
R

RagDyer

Try this:

=LOOKUP(2,1/(1-ISBLANK(A1:A1000)),A1:A1000)

Will work with blank cells within the column, but don't use entire column
references (A:A).
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top