Last cell in column

Is there a formula to get show the last cell in the column with information?
example:
4.5
6.6
7.8
3.4

Need formula to show 3.4 since it is the last cell in the column with any information in it.

I am using Excel 2000

Thanks,
dcoates

Hi,

One way is:

Please Login or Register  to view this content.

Adjust column A as necessary.

HTH

I tried both formulas. If I try to find the last number I get 0 as my answer. If it try to find the last name in a column, I get #N/A. This happens with both formulas.

We're getting there. The =Lookup(Rept("Z",255),A:A) works if there is only text in the column. If there is a mixture of time and text, it will return only the text.

The 1st two formulas will return date and time information but text will return #N/A.

One other option would be to use this code in the worksheet selection change event

Please Login or Register  to view this content.

It will automatically enter in B1 the last value in column A whenever a change is made on the sheet.

HTH

Thank you. I used a combination of the formulas to achieve the results I was looking for. I am not familiar with codes to be able to use the last suggestion.

Thanks for you invaluable assistance. Makes our lives so much easier.

dcoates