SOLVED

Matching entries in a single row throughout several entries

Copper Contributor

Matching entries in a single row throughout several entries

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?

3 Replies

Re: Matching entries in a single row throughout several entries

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

Re: Matching entries in a single row throughout several entries

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``

Re: Matching entries in a single row throughout several entries

THANK YOU! @Patrick2788

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

Re: Matching entries in a single row throughout several entries

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``