How do I display the last entry in a list
Hi,
This does it for column A
=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A65535))*(A1: A65535<""))))
Mike
"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?
|