View Single Post
 
Old 02-21-2021, 03:56 AM
glenhmalnv2d1 glenhmalnv2d1 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2021
Posts: 3
glenhmalnv2d1 is on a distinguished road
Default Match values on different columns based on criteria

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!
Reply With Quote