In article ,
terri wrote:

Is there any formula to tell me what the last line of data in a column is?
-- for example if data ends in cell A45 -- is there a formula that would look
a column a and return A45?

Do you want to return the contents of A45 or the cell reference A45?

Does Column A contain text or numerical values? Or does it contain both?

--
Domenic
http://www.xl-central.com