Home > front end >  Count when two values exist in column B with the same value in column A
Count when two values exist in column B with the same value in column A

Time:11-07

I have a database which looks like this (attached)

enter image description here

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

CodePudding user response:

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.

  • Related