Bob Phillips' with the help of the late Frank Kabel explains this formula and
many others for getting the last cell in a range.

http://xldynamic.com/source/xld.LastValue.html#S012


Gord Dibben MS Excel MVP

On Sat, 07 Jul 2007 08:11:53 GMT, "adeel via OfficeKB.com" <u32736@uwe wrote:

Thanks alot Mr. Dibben your Formula Help is perfect. and I have find the
solution with this.
Now kindly explain me this formula, that what logic you use. i will be highly
thankful to you.

adeel

Gord Dibben wrote:
Jay

Try this formula to get last filled cell(numeric or text) in column A

=LOOKUP(2,1/(A1:A65535<""),A1:A65535)

Gord Dibben MS Excel MVP

Use a formula like the following array formula:

[quoted text clipped - 12 lines]
How is your formula supposed to work? I can't figure out the logic.
Thanks.