How do I display the last entry in a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ozsteve - 03 Dec 2007 10:02 GMT

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?

Reply to this Message

Mike H - 03 Dec 2007 10:36 GMT

Hi,

This does it for column A

=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A65535))*(A1:A65535<>""))))

Mike

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

Reply to this Message

ozsteve - 03 Dec 2007 10:46 GMT

Hi Mike
Thanks for the reply. I'm sure if understood it I could get this to work,
but Gary's response below works a treat out of the box and suits my needs.

Thanks for your input.

Steve O

> Hi,
>
[quoted text clipped - 7 lines]
> > last entry (ie highest row number) in the list to another cell. Can this be
> > done?

Reply to this Message

Gary''s Student - 03 Dec 2007 10:38 GMT

=LOOKUP(99^99,A:A)

for column A

Signature

Gary''s Student - gsnu200759

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

Reply to this Message

ozsteve - 03 Dec 2007 10:43 GMT

Hi Gary,

Thanks for the quick reply. that does the trick perfectly.

Steve O

> =LOOKUP(99^99,A:A)
>
[quoted text clipped - 3 lines]
> > last entry (ie highest row number) in the list to another cell. Can this be
> > done?

Reply to this Message

Rate this thread: