Also,
In J3 with CTRL+SHIFT+ENTER,
=IF(SUM(COUNTIF($B3:$H3,IF($B$14:$H$14=LEFT(J$2,FIND(" ",J$2)-1),$B$13:$H$13))),"Yes","No")
Then copy across & Down.
Also,
In J3 with CTRL+SHIFT+ENTER,
=IF(SUM(COUNTIF($B3:$H3,IF($B$14:$H$14=LEFT(J$2,FIND(" ",J$2)-1),$B$13:$H$13))),"Yes","No")
Then copy across & Down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Fantastic guys. txs!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks