last nonblank
Non-array, non-volatile formula for contents of last, non-blank cell in a
range:
=LOOKUP(2,1/(A1:A100<""),A1:A100)
For last non-blank text
=LOOKUP(REPT("z",255),Sheet1!e1:e100,Sheet1!e1:e10 0)
You can shorten that to:
=LOOKUP(REPT("z",255),Sheet1!e1:e100)
Last non-zero
=LOOKUP(2,1/(B7:H7<0),B7:H7)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"TomHull" wrote in message
...
Hi,
I need a formula that finds the first empty cell at the bottom of a column
of data. I have tried using the find and select function in a macro and it
fails to find cells often. Have also tried using a MATCH formula but it
doesnt seem to like finding an empty cell.
Any Help,
Thanks
Tom