Excel help

[Messiah Khan]

Anyone got any idea how you reference the last cell that has data in a column? I basically have list that goes down a column and need whatever the bottom value is to be copied into another cell. Any ideas?

 

[Messiah Khan]

Thanks guys. That seems to have worked a treat. Another related problem though. Some of the data in those cells comes from formulas. But if no data has been entered in the related cells, the formula displays say 0.00, which obviously is picked up as the bottom value. Is there any way of saying show the bottom value in a column as long as it is over 0.00 (Or any other value that I specify as some formulae defaults are 1.04030 for example.)?