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

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.

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

"Knightrider" wrote in message
...
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.

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!
==============================================


"Knightrider" wrote in message
...
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.