In K10, copied down:
=IFERROR(INDEX($A$10:$A$17,MATCH(0,INDEX(COUNTIF($K$9:$K9,$A$10:$A$17),0),0)),"")
In J10, copied down:
=IF(SUMPRODUCT(($A$10:$A$17=K10)*($C$10:$C$17>=$C$7))>0,1,"")
In K10, copied down:
=IFERROR(INDEX($A$10:$A$17,MATCH(0,INDEX(COUNTIF($K$9:$K9,$A$10:$A$17),0),0)),"")
In J10, copied down:
=IF(SUMPRODUCT(($A$10:$A$17=K10)*($C$10:$C$17>=$C$7))>0,1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks