It worked great, thanks,

Harold


"Sandy Mann" wrote in message
...
One way:

=LOOKUP(2,1/(A1:A150),A1:A15)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Harold Good" wrote in message
...
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