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.
|