View Single Post
  #1   Report Post  
Harold Good
 
Posts: n/a
Default find last cell in column - without VBA

Hi,

Apart from using VBA, is there any way to write a formula that will find the
last used cell in a column of 15 cells? In the first set below, it would be
..388, in the second set it would be .133. Any help would be appreciated.

0.006
0.000
0.036
0.125
0.133
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.313
0.388



0.006
0.000
0.036
0.125
0.133
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000