Matching entries in a single row throughout several entries

[KUKS_42]

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?

[#2]

@KUKS_42 

Open for interpretation. So every solution is correct.

=IFERROR(MIN(1/(1/(COUNTIFS(total_range,row_range)-1))),0)>0

[#3 · Accepted solution]

@KUKS_42 

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:

=COUNTIFS($B$3:$B$24,$B3,$C$3:$C$24,$C3,$D$3:$D$24,$D3,$E$3:$E$24,$E3,$F$3:$F$24,$F3,$G$3:$G$24,$G3,$H$3:$H$24,$H3,$I$3:$I$24,$I3,$J$3:$J$24,$J3,$K$3:$K$24,$K3)>1

[#4]

THANK YOU! @Patrick2788