Forum Discussion
Comparing Duplicates in Column A with Duplicates in Column B
I solved it using the following formula:
=AND(COUNTIFS($A$2:$A$11,A2,$B$2:$B$11,B2)>1,C2="Primary")Thanks for the help everyone!
Hi SergeiBaklan and OliverScheurich - you have both given me answers which are actually really close to what I need, but I realised there's another complication to my data. I would actually like to pull out "Banana" as "True" as well, but only because its duplicate values are the highest values. If there was another "Orange - 5", I wouldn't want to include it as "Orange - 10" is higher.
Essentially, my data looks like this:
Fruit Quantity Primary
Apple 10 Primary
Apple 10 Primary
Apple 10 Primary
Banana 5 Primary
Banana 5 Primary
Banana 4 Duplicate
Orange 10 Primary
Orange 3 Duplicate
Orange 3 Duplicate
And I'd like to pick out where there is more than one Primary row per duplicate fruit. The primary record is the duplicate with the highest quantity score.
Sorry, I didn't catch. Would you like "Banana 4 Duplicate" also shall be included? Perhaps you may add column within your file with results as they shall be in accordance to your logic.
- Hi SergeiBaklan - no worries, I figured it out in the end by using the text column as a match.