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
Solved! Go to Solution.
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.
Hello cplewis90
I need to have just the persons that they went only to one coffee and no both. For example
Please, see the dataset bellow
Thanks !
Hey @ImadM
The solution I attached should work for this. In the first attachment the ages were different on those two people. It should work to remove any duplicates.
Let me know if it does not and I will revisit the solution.
Great! Yes it works
Thanks a lot 🙂