You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Shane Goodman" wrote in message
...
Biff,

It worked! I have trouble understanding anything nested three or more
times, so I just copies it exactly and replaced the range values.

Thanks for your help.
Shane.

"T. Valko" wrote in message
...
Try this array formula** :

=COUNT(1/FREQUENCY(IF(A2:A10<"",IF(B2:B10<"",MATCH(B2:B10 ,B2:B10,0))),ROW(B2:B10)-MIN(ROW(B2:B10)+1)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP