getting the last cell value in a column

[amrezzat]

Heloo

if i have 1 and it is so long say may be more than 1000 rows

1
2
3
453
566
4465
352
2
3434


how can i get the last number in it??
although each cell is a formual not blank

 

[Ron Coderre]

Since there can be alternatives in what you want check this website:
http://www.xldynamic.com/source/xld.LastValue.html

Does that help?

***********
Regards,
Ron