You're welcome. Thanks for the feedback!

BTW, the formula in column C can be further simplified to:

=IF(B3="",0,1/(LEN(B3)-LEN(SUBSTITUTE(B3,",",""))+1))

I think I used Sumproduct because I still had "arrays" on my mind!

Biff

"Randhir" wrote in message
...
Biff this is awesome!! Thanks a ton - a bunch of people I asked for help
told
me it could not be done, but you proved them wrong!! This works
beautifully.