Unique Counties from multi County table

[zraj07]

I have a "table" or an "array" that consists of names of Counties.
Sometimes the counties are duplicated in the array.
I have a Master List of Counties.

I am trying to check and see, if, in my array, I have at least one of each of the counties contained in the master list. Intent is to be able to show that I have not missed any counties in my array.
perhaps something that would indicate as below, only 5 of the 7 counties matched the master list but somehow doesn't doublecount the duplicate counties?


Any suggestions?

ARRAY:
County County2 County3
Dakota Fillmore
Filmore Washington
Ramsey Goodhue Dakota

Master list:
Dakota
Fillmore
Goodhue
Mower
Olmsted
Ramsey
Washington

 

[snoopyhr]

Excel Workbook
	A	B	C
1	ARRAY:
2	County	County2	County3*
3	Dakota	Fillmore
4	Fillmore	Washington*
5	Ramsey	Goodhue	Dakota
6
7	I am assuming you want to see if the name
8	in the Master List does exists in your array
9
10	Master list:
11	Dakota	2	Exists in the Array
12	Fillmore	2	Exists in the Array
13	Goodhue	1	Exists in the Array
14	Mower	0	Not in the Array
15	Olmsted	0	Not in the Array
16	Ramsey	1	Exists in the Array
17	Washington	0	Not in the Array
Sheet1

C11 is optional if you want more description of the status.

But I think I am missing something as this too easy, let me know if it works

 

[zraj07]

This is exactly what I was going after! And it worked for me.
Yes, seems too simple..
but I haven't run into issues where I've had to use COUNTIF, so it did not dawn on me until I saw a similar example on the board..

I thank you for this assitance!