Hi all,
I am trying to set up a spreadsheet for our works football tipping competition, I want it to automatically Identify who has tipped the same across all the games for that week and to enter the comment - Can't Win and put the name of the person who has tipped the same in column B, I have attached a sample spreadsheet of what the end result should be.

NOTE: the spreadsheet should have nine columns after the names because as of next year there will be 18 teams.

Also there is currently 16 names - I will need at least 20 names please.



I hope someone can help!!!!

Regards
Frustrated - with formulas

Football Tipping - Copy.xlsx