How do I display the last entry in a list
Hi Gary,
Thanks for the quick reply. that does the trick perfectly.
Steve O
"Gary''s Student" wrote:
=LOOKUP(99^99,A:A)
for column A
--
Gary''s Student - gsnu200759
"ozsteve" wrote:
In Excel 2003, I have a list of values in a column and want to return the
last entry (ie highest row number) in the list to another cell. Can this be
done?
|