Hi,I would like to get the data from same row or same coloum(which last
figure shown in same row or colum).

Example as below,

A1=15/3/2008
A2=25/4/2008
A3=nothing shown
A4=nothing shown
A5=Yes
A6=No
A7=nothing shown

A15 = I hope I can get the last figure or date or word shown in the same column (ie.No).

If all the coloum is blank then show with "-" , any solution ?

Thanks.