nav2567
asked on
File compare
I have two txt files. File A contains over 500 names. File B contains about 100 names.
Is there a utility out there which allows me to highlight all names in file A which appear in File B?
Please advise.
Is there a utility out there which allows me to highlight all names in file A which appear in File B?
Please advise.
You can also use a formula like this in column B
=IF(ISNA(MATCH(A1,'[Book2. xls]Sheet1 '!$A:$A,0) ),0,1)
Then select column A and enter a conditional formatting using this formula
=B1
Select a format and hit OK. All matched names will now have the format you chose. You can hide column B.
cheers, teylyn
=IF(ISNA(MATCH(A1,'[Book2.
Then select column A and enter a conditional formatting using this formula
=B1
Select a format and hit OK. All matched names will now have the format you chose. You can hide column B.
cheers, teylyn
ASKER
let's say if my book1.xls has:
apple
bee
cat
dog in column A, and my book2.xls has:
bee
moose
apple
tiger in column A.
I'd like my book1.xls column B displays in a way like this:
apple match
bee match
cat not match
dog not match
I tried to put the following in B1 of book1 but did not work:
=IF(ISNA(MATCH(A1,'[c:\tes t\Book2.xl s]Sheet1'! $A:$A,0)), "not found", "matched")
Please advise again. Thanks.
apple
bee
cat
dog in column A, and my book2.xls has:
bee
moose
apple
tiger in column A.
I'd like my book1.xls column B displays in a way like this:
apple match
bee match
cat not match
dog not match
I tried to put the following in B1 of book1 but did not work:
=IF(ISNA(MATCH(A1,'[c:\tes
Please advise again. Thanks.
ASKER
Sorry. I still cannot get it to work.
File one has a lot more names than file two. The goal is to see the names in file 2 show "matched" in file one
Thanks.
File one has a lot more names than file two. The goal is to see the names in file 2 show "matched" in file one
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
with both files open, enter this formula into Book1, where the other file is named Book2 and the names are in column A in each file:
=IF(ISNA(MATCH(A1,'[Book2.
copy down.
cheers, teylyn