Duplicates with conditions

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!

Help

Accepted answers

ArtApa

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

DuplicatesAA.yxmd

All comments

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.

Respuesta Comunidad.png

ArtApa

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

DuplicatesAA.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335