I want to compare the values in two columns
 

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?

I want to compare the values in two columns
 

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","N o"))
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dr. Darrell" wrote:
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?

I want to compare the values in two columns
 

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.

"Dr. Darrell" wrote:

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?

I want to compare the values in two columns
 

Thanks you, this worked very nicely.

Darrell

"Max" wrote:

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","N o"))
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dr. Darrell" wrote:
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?

I want to compare the values in two columns
 

You're welcome, Darrell !
Thanks for feeding back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dr. Darrell" wrote:
Thanks you, this worked very nicely.
Darrell