Maybe the below formula in cell L2 and drag accross:
=COUNT(FILTER($G$2:$I$13,(COUNTIF($I$2:$I$13,$I$2:$I$13)>1)*($G$2:$G$13=L1)))
Maybe the below formula in cell L2 and drag accross:
=COUNT(FILTER($G$2:$I$13,(COUNTIF($I$2:$I$13,$I$2:$I$13)>1)*($G$2:$G$13=L1)))
Posting Permissions
Reply With Quote