Comparing two lists

  • Thread starter Thread starter sixpilot
  • Start date Start date
S

sixpilot

I have two lists of phone numbers and need to determine if
any of the numbers on the first list are contained in the
second list.

Also one list is prefaced with the 1- in front of the area
code. I need a way to remove it. I can't do a replace 1-
or it will remove other instances and the list is too long
to process manually.

Thanks
 
sixpilot wrote ...
I have two lists of phone numbers and need to determine if
any of the numbers on the first list are contained in the
second list.

Also one list is prefaced with the 1- in front of the area
code. I need a way to remove it. I can't do a replace 1-
or it will remove other instances and the list is too long
to process manually.
Click to expand...

Sixpilot,

**Stripping the 1**

Depending on your data, you might use something like

=Right(A1,10) ...meaning take the 10 most character from the right on cell
A1. You might have to adjust this depending on how your data is displayed

**Determining if there is duplicate in the other list**

=IF(ISNA(MATCH(A1,List2,0)), "Unique","Duplicate")

Hope that helps.

Best regards,
Kevin
 
Thank you!! That did it. I have been sitting here
beating my brains out to figure this out. I guess I need
to take a class! Well at least this will take care of the
dillema tonight!

I really appreciate the help
 
sixpilot ...
Thank you!! That did it. I have been sitting here
beating my brains out to figure this out. I guess I need
to take a class! Well at least this will take care of the
dillema tonight!

I really appreciate the help
Click to expand...

Sixpilot,

You are most welcome.

Best regards,
Kevin
 
Back
Top