Duplicates with conditions

[JohnO]

Hi all,

I need to figure out a way to get certain customer based on customer number and region. Basically, I need all of the region A customers UNLESS there is a region B listed then I need that one.

My list should look like this:

Thanks for the help!

[BrandonB]

The Unique tool will pass the first row of each value based on the box checked, so if you sort it first then you should be all set. Just use a sort tool and say Region descending and then use a unique tool where you check the box for customer. 

[Hannia_Ruíz]

Hi @JohnO 

I can see that your data has two regios A and B, so you can use "Summarize" asthe image shows.

[ArtApa · Accepted solution]

Hi @JohnO - You can achieve this in a couple of ways. I took the two already described here and added one more: