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!
Solved! Go to Solution.
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.
Hi @JohnO
I can see that your data has two regios A and B, so you can use "Summarize" asthe image shows.
Hi @JohnO - You can achieve this in a couple of ways. I took the two already described here and added one more: