You're welcome. Thanks for the feedback!

Biff

wrote in message
oups.com...
Jackpot! I was way off, mucking around with various SUMPRODUCT
arrays... Thanks!

..o.

On May 25, 11:41 am, "T. Valko" wrote:
Try this array formula**

=COUNT(1/FREQUENCY(IF(status="Yes",MATCH(name,name,0)),ROW( name)-MIN(ROW(na*me)+1)))

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

Biff