Alain,

Yes that is it. Remember to array enter it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mcs51mc" wrote in
message ...

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