Data select

ImadM

Hello !

I have 2 dataset which describe a list of people that they went to two different coffee A and B.

I would like to know all persons that they went at least one time to one coffee and not both. I tried unique tool but I think that I need a formula to select target data. 

Do you have any idea please?

Thank you

DATA.xlsx

cplewis90

Hello @ImadM,

I am not sure if this is exactly what you are looking for. There is also a bit of a manual aspect to this in the select records tool. I probably could get to a more automated solution with a bit more thought.

Unique Customers.yxmd