Matching entries in a single row throughout several entries

New Contributor

First time posting

Thank You


I run an office pool which has several people involved where each person has to select 10 different golfers per entry

I enter everyone's selections in a single row

I want to find if someone entered the same 10 golfers as someone else

I attached a picture of the spreadsheet

What formula do I use for this?EXCEL SS.png



3 Replies


Open for interpretation. So every solution is correct.



best response confirmed by Hans Vogelaar (MVP)


If you want to indicate the rows that match visually, you could opt for conditional formatting and use COUNTIFS().  It's a bit long but it's simple and easy to understand: