I want to compare the values in two columns

[Guest]

I have a list of 1,000 Document Titles in Column A and I have a list of 1,200
Document Titles in Column B.

I would like to compare the tiltes in Column A to those in Column B. Ideally
all 1,000 titles from Column A should be in Column B as well.

Is there a function in Excel to allow me to identify all the titles in
Column B that are equal to the Titles in Column A?

 

[Guest]

I typed in "Compare" in the help section under Indexed and found a formula
using OR and EXACT together. Check it out and see what you get.

 

[Guest]

Assuming data in cols A and B, from row2 down,

Put a label in C1, say: "Is B in A?"
Put in C2:
=IF(B2="","",IF(ISNUMBER(MATCH(B2,A:A,0)),"Yes","No"))
Copy down to the last row of data in col B

Col C will return "No" for titles in col B not found in col A, "Yes" if
found. Then just do a Data > Filter > Autofilter on col C, and select "No"
from the droplist in C1 to filter out these cases for closer inspection.

 

[Guest]

Thanks you, this worked very nicely.

Darrell

Assuming data in cols A and B, from row2 down,

Put a label in C1, say: "Is B in A?"
Put in C2:
=IF(B2="","",IF(ISNUMBER(MATCH(B2,A:A,0)),"Yes","No"))
Copy down to the last row of data in col B

Col C will return "No" for titles in col B not found in col A, "Yes" if
found. Then just do a Data > Filter > Autofilter on col C, and select "No"
from the droplist in C1 to filter out these cases for closer inspection.

 

[Guest]

You're welcome, Darrell !
Thanks for feeding back ..