You're welcome, Chris !

Roger's formula as posted had only a slight typo.
( It's much neater !)

.. I assume that in the second half of the formula the array is b2:f2
again

Think it should be 2:2

Try array-entering in F2 as:

=INDEX(B2:E2,MATCH(TRUE,
(B2:E2<""),0))-INDEX(2:2,0,MAX((B2:E2<"")*(COLUMN(B2:E2))))

Then just copy F2 down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ted Metro" wrote in message
...
Thanks Max and Roger!

Max your solution worked perfectly!! I couldn't get Roger's to work
however. I assume that in the second half of the formula the array is
b2:f2
again (I think your ":2" is just a small typo in your e-mail back to me).

Chris