Hi,
I have two large lists of text (approx 3000 items long) that I would like to compare with each other - some names feature in both lists. Is there a way to compare the two lists, other than manually, with a view to generating a new list of the names that only appear in one of the lists?
Many, many thanks for your help
Stuart
You can use the Match() function to return #N/A when no match found...
=Match(A1,ListRange,0) copied down.
where A1 is the 1st item to look for in ListRange (a single-column range, e.g. D:D or $D$1:$D$1000
If a number is returned a match is found at that position in the ListRange. If a #N/A error is returned, then no match is found.
You can repeat for the other table.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks for your suggestion - played around with it and now am using:
=OR(EXACT(B,A:A))
gives true or false value
Are you sure that is working for you as intended... with my limited testing (and I assumed you meant OR(EXACT(B:B,A:A)) or OR(EXACT(B1,A:A)) ) I did not get a True value when I expected oneOriginally Posted by stuarthill27
That only compares A1:B1
Yep, using:
OR(EXACT(B1,A:A))
where A:A is the whole search range (which doesn't change)
Wrote a quick macro as I needed to press F2 and then ctrl+shift+enter to get it to work properly for each entry
It seems to have worked fine but am having to manually double check as it does mean exact (includes letter casing) but that is fine as it has reduced the amount of names that I've got to manually check by 500 or so
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks