Formula or Pivot Table or something else to remove duplicate entries

I am not sure what steps I would need to follow to get this 3 column worksheet to eliminate non-unique entries.

What I am trying to accomplish is:

Column A - Account Number
Column B - Account Name
Column C - Distributor Name

If column A and column B match then look to column C

If there is a different distributor names in Column C, remove.

The end result we are looking for would be to leave only the UNIQUE data consisting of only those accounts with ONE distributor.



see attached

Please explain why you end up with the two results. i.e explain which of the original cells are use to create the result and why are they picked and the others ignored.

One way!

In D2 copied down:

=COUNTIF($A$2:$A$11,A2)

Now sort the entire range on column D (smallest to largest) and delete all rows below the last 1.

I think you need to give us a broader set of sample data.

Originally Posted by AliGW

I think you need to give us a broader set of sample data.

As Ali said, More data please

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before. You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

This proposal employs a helper column (D) which may be moved and/or hidden for aesthetic purposes.
The helper column is populated using: =AND(COUNTIFS(A$2:A$810,A2,B$2:B$810,B2,C$2:C$810,C2)=COUNTIFS(A$2:A$810,A2,B$2:B$810,B2),COUNTIFS(A$2:A$810,A2,B$2:B$810,B2)=COUNTIFS(A$2:A$810,A2))
A pivot table is then produced with the three original fields placed in the Rows area and the helper field placed in the Filters area.
The filter is set to only display those records where the helper column displays TRUE.
Let us know if you have any questions.

@JeteMc - This works perfectly!

Thank you for your input and solution

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.