Hi,
I have two files, and I want to compare all the values in one column in file A to all the values in one column in File B, and find out which ones appear in both files.
The order is random. For example, say I am comparing girl's names.
In file 1, a column has:
Fran
Jill
Hope
Joanne
In file 2, a column has:
Jill
Patty
Suzy
Hope
I am looking for a way to compare the names in these columns and find the ones that appear in both files (Hope and Jill). Is this possible?
Thanks.
Advanced Filter will do that.
Both lists have to have identical headers.
The formula style of Criteria requires an empty cell as a header in C1.
If C2 has the formula =ISNUMBER(MATCH(A2,Sheet2!A:A,0))
Filtering with ListRange = Sheet1!A:A and CriteriaRange C1:C2 will show everything that is in both lists. The Copy to Other location and Unique can be altered to meet your needs.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks