![]() |
#1
|
|||
|
|||
![]()
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! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
![]() |
caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
transpose values based on mulitple criteria | mlttkw | Excel | 1 | 12-06-2013 02:00 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |