Match values on different columns based on criteria

p45cal · #1 02-21-2021, 06:03 AM

Not especially easy.
In the attached:
1. In Sheet1 a solution which may not work in Excel 2016 involving FILTER and UNIQUE.

2. In Sheet2 a Power Query in cell H1. Right-click and choose Refresh to update.

glenhmalnv2d1 · #2 02-21-2021, 11:34 PM

Thanks a lot for the help!!! thank you so much!

I have tested the solution in Sheet 2 and changed some values, but seems that the query is not working properly, i am still getting same output values in H1; any suggestion what am I doing wrong? thank you!

p45cal · #3 02-22-2021, 06:25 AM

Quote:

Originally Posted by glenhmalnv2d1

I have tested the solution in Sheet 2 and changed some values, but seems that the query is not working properly, i am still getting same output values in H1

1. You have only 3 distinct names in column A so what would you expect - unless you want names repeating?
2. You said:

Quote:

Originally Posted by glenhmalnv2d1

have at least 3 matching values (same values) on column "City"

The cities you've added are different.

Are you looking to list names where:
each name appears in at least three different cities
or:
the names in cities where there are at least 3 different names in one city (this is what I've done)
or:
something else?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Count unique values that match 2 or more criteria	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