My first answer works only with numbers

This works with text also but with no blank cell in the column before last
item
=INDIRECT(ADDRESS(COUNTA(D1:D500),4)) for column D
=INDIRECT(ADDRESS(COUNTA(K1:K500),11)) for column K

best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Lawman" wrote in message
...
In an expression, how do I refer to the last cell in a specified column
that is not blank?

Thanks in advance.

H