Excel question!

[kennysarmy]

I've got 6 columns of names.

 

Each column has names which only appear in that column.

 

EG.

 

Player Player Player Player Player Player

Brooks Koepka Tyrrell Hatton Rickie Fowler Martin Kaymer Brandon Stone Mark Geddes

Bryson DeChambeau Abraham Ancer Charley Hoffman Lanto Griffin Andy Sullivan Danie Tonder

Bryson DeChambeau Matthew Fitzpatrick Kevin Na Phil Mickelson Padraig Harrington Chan Kim

Bryson DeChambeau Tommy Fleetwood Jason Kokrak Francesco Molinari Jazz Janewattananond Alex Beach

Bryson DeChambeau Tyrrell Hatton Jason Kokrak Victor Perez Mackenzie Hughes Takumi Kanaya

Bryson DeChambeau Justin Rose Max Homa Kevin Kisner Brian Gay Tim Pearce

Bryson DeChambeau Will Zalatoris Billy Horschel Francesco Molinari Adam Hadwin Joe Summerhays

Cameron Smith Corey Conners Max Homa Harold Varner Mackenzie Hughes Chez Reavie

 

 

Is there a way to check which rows might have 5 matches with each other or have 4 matches?

[NixNerd]

This proposed solution doesn't fully answer your question, however it may get you some of the way there:

 

https://smallbusiness.chron.com/use-excel-show-only-duplicate-values-47521.html

 

[Seb1780]

Analogous to lottery tickets!

 

https://www.extendoffice.com/documents/excel/4988-excel-highlight-lottery-numbers.html

[kennysarmy]

I really couldn't work out a way to do it

 

Ended up re-ordering via two columns and then visually checking if any of the other columns had a match and highlighting.