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!

Attached Images

Excel question - updated - detail.png (149.0 KB, 18 views)

Attached Files

Excel question - updated.xlsx (9.7 KB, 8 views)