Thanks,
I think I understand your formulas, now.

I learned a few tricks in that thread.
Always a good thing...

Regards,
Luc
--
Festina Lente


"Harlan Grove" wrote:

PapaDos wrote...
....
Isn't the last term of your "hardcoded" one wrong ?
A probable typo error, I think it should be ROW($A2:$A8) instead of
ROW($A2)...
....

Not a typo, a mistake. It should be

=COUNT(1/($B2:$B8=D2)/IF($A2:$A8="Unfilled",1,MATCH($A2:$A8,
IF($B2:$B8=D2,$A2:$A8),0)-1+ROW($A2)=ROW($A2:$A8)))