Hi

I am trying to extract from the first column "Name" the matching values from a 2nd Column "City", only if I have at least 3 matching values on column "City".

Basically trying to find all the values in column "Name" that have at least 3 matching values (same values) on column "City".

I have put together an Excel sheet here:
Dropbox - Excel question.xlsx - Simplify your life

and here is a screenshot of what I mean:
Dropbox - Excel output notes.png - Simplify your life

I have tried a few formulas like Index, Match etc but no success, not getting the same output.

Does anyone have any solution or idea on how I can make this work, to get that output?


(check the screenshot, looking to get the names values)

Thank you so much!