Hi Bob,

I tried out your formula but it didn't work well

Is this what your formula should do?
1) list with blanks in cells A1:A20
2) copy 20 times your formula in, let say, C1:C20 so that this range
contains no blanks (except at the end af course)

Thanks for any reaction
Alain


--
mcs51mc
------------------------------------------------------------------------
mcs51mc's Profile: http://www.excelforum.com/member.php...o&userid=28645
View this thread: http://www.excelforum.com/showthread...hreadid=482204