Getting last entry in a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wwfc_barmy_army - 31 Oct 2004 16:41 GMT

hi,

I've got a 'quotation system' and i need to work out a way, so when
press i button (I've got the button) it recognises the last entry pu
in 'Customer Details'.

I just need some idea of the marco or whatever i will have to use.

Can anyone give me any ideas on how i can do this.

Thanks.

Pete

Reply to this Message

Alan - 31 Oct 2004 18:09 GMT

To find the last row of data try
=LOOKUP(2,1/(Data!A$1:A$20000<>0),ROW(Data!A:A))
use this with
="A"&LOOKUP(2,1/(Data!A$1:A$20000<>0),ROW(Data!A:A))
etc
Cant remember who posted it (sorry) but its really good,
Regards,
Alan.
This incredible formula (and it works!) was posted on the neswgroups not
that long ago

> hi,
>
[quoted text clipped - 9 lines]
>
> Pete.

Reply to this Message

Gord Dibben - 31 Oct 2004 18:46 GMT

Pete

See Bob Phillips' site for various ways to find/return last value in a range.

VBA not required, but code is available there if wanted.

http://www.xldynamic.com/source/xld.LastValue.html

Gord Dibben Excel MVP

>hi,
>
[quoted text clipped - 9 lines]
>
>Pete.

Reply to this Message