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?