# Find majority match in groups of cells

#### nosila

##### New Member
I'm analyzing Mechanical Turk results. Each assignment was done three times, and I want to find all sets of three assignments that were agreed upon by the majority (2/3 or 3/3) of respondents.

Here's the basic setup:

 NAME STATUS Org 1 active Org 1 not.active Org 1 not.active Org 2 in.db Org 2 in.db.missing.info Org 2 not.in.db

<tbody>
</tbody>

As you see, there is a majority agreement (2/3) for Org 1, and no agreement (three different answers) for Org 2. Both columns contain strings. I know how to use EXACT, but I'm not sure how to do it in groups of three rows.

I need to find a way to tease out two things:
1. Which organizations were not agreed upon by a majority (contained three different answers)? I'll need to flag these for review.
2. When there was majority agreement, I need to create a list with the organization name and the correct status. It would be fantastic if I could also include all of the other data (not shown here) associated with each organization.

I've been using this board a lot lately, and always see great answers. This is one I couldn't find by searching. Thanks in advance for your help!

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Welcome to the MrExcel message board.

Assuming row 1 is header row
Col A = Name
Col B = Status
Col ?? = Results (this is where we're putting the formula) beginning in row 2 of this column

=IF(COUNTIFS(A:A,A2,B:B,B2)=1,"Review","Majority")

Now, regarding pulling a list of the "Majority" organizations & consensus status:
You didn't say what kind of "other" data, but a quick way to compile a list would be to create a pivot table
Results go in Report Filter section (filter to "Majority")
In Row Labels section put Name & Status with NO subtotals

 NAME STATUS Org 1 active 1 MAJ Org 1 Org 1 not.active 2 Org 1 not.active 2 Org 2 in.db 1 NO MAJ Org 2 in.db.missing.info 1 Org 2 not.in.db 1 in F7 =COUNTIF(E\$7:E\$9,E7) in g7 =IF(SUM(F7:F9)>3,"MAJ","NO MAJ") in h7 =IF(G7="maj",D7,"") F7 is the top 1 in the column 122111

<colgroup><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>

Replies
3
Views
242
Replies
0
Views
592
Replies
11
Views
2K
Replies
0
Views
327
Replies
2
Views
286

1,211,984
Messages
6,105,219
Members
447,957
Latest member
Basildon

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back