Do Not Call List Spreadsheet

Dear Experts:

I need a spreadsheet that compares a list of numbers with another list, and finds matching numbers sends them to different locations.

Suppose you have the following data:

Column "A" is: "This is a Do Not Call List Phone Numbers - not to be called"
2132000005
2132000008
2132000009
2132000019
2132000020
2132000021
2132000023
2132000024
2132000028
2132000030

Column "B" is: The list that you want to filter out. This list is raw.

2132000028
2132000030
2132000031
2132000035
2132000041
2132000045
2132000051
2132000053
2132000058
2132000059
2132000064
2132000065
2132000066
2132000067
2132000079
2132000080
2132000097
2132000100
2132000103
2132000104
2132000110
2132000113
2132000116
2132000119
2132000122

Now we need to match column "A" with COlumn "B" and copy duplicates to Coulumn "C" or: (These two numbers appear in both "A" and "B")

2132000028
2132000030
(notes these numbers are also found in list "A")

And the remaining unique numbers that are not part of list "A" to Coulumn "D" or:

2132000031
2132000035
2132000041
2132000045
2132000051
2132000053
2132000058
2132000059
2132000064
2132000065
2132000066
2132000067
2132000079
2132000080
2132000097
2132000100
2132000103
2132000104
2132000110
2132000113
2132000116
2132000119
2132000122
(Note: these items are not found in list "A")

I've very limited programming experience in Excel, and I appreciate if someone can actually write the above if & match statements and post or email a reply, with an actual database.

Please do not post a reply for the sake of showing your signature part.

Thanks in advance
cbahman@yahoo.com

Hi

Assuming that your data as shown, with some headings is in the range A1:B26, and C1:D1 contain some headings (say Matches, and No Match), then try

Please Login or Register  to view this content.

rylo