Hi
actually you are correct, it is showing the right output for me; I tested the Sheet2 and that's the one working well for me; Sheet1 did not work that well.
So I am looking to list names where each name appears in at least 3 different cities.
That being said, if I may kindly ask if you can help with a tweak to the problem?
I am trying to group the list of names in column F for instance, and on column G to display de-duplicated values of the City that are matching those Name values.
Basically i am trying to get the same output like you did, but also get the corresponding City and also there will be separate groups of Name.
The problem i am having is that i need to compare all the combinations of Name that have different cities (same rule applies at least 3 cities per each name from that group).
I am finding hard to get a solution for this : (
I have attached the updated file and a screenshot if you don't mind me asking if you can help with this as well @p45cal ?
Thank you so much!
|