I have a database which looks like this (attached)
And I am trying to see if 8808 has played each of the players from cell E5 downwards.
I have tried SUMPRODUCT formulae, but this did not work!
Thanks for the help, really stuck on this one
>Solution :
Assuming the data occupying columns A and B is held within a table named Table1, in F6:
=IF(SUM(COUNTIFS(Table1[Player ID],E6,Table1[Race ID],UNIQUE(FILTER(Table1[Race ID],Table1[Player ID]=F$3)))),"Yes","No")
and copied down.