SOLVED

Matching entries in a single row throughout several entries

Copper 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

@KUKS_42 

Open for interpretation. So every solution is correct.

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

 

best response confirmed by HansVogelaar (MVP)
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

 

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
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

 

View solution in original post