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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1