I want to compare the values in two columns

D

Dr. Darrell

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?
 
W

WLMPilot

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.
 
M

Max

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.
 
D

Dr. Darrell

Thanks you, this worked very nicely.

Darrell

Max said:
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.
Click to expand...
 
Top