I have two separate columns of numbers. Each cell in both columns
contains a 9 digit telephone number. The first column has about
50,000 cells/numbers. The second column has about 2,000 cells/numbers
(formatted slightly differently, with a space after the area code).
I need to identify the matches there are for each of the 2,000
telephone numbers in the 2nd column from among the 50,000 cells in
column one.
Any numbers that I'm not able to match up in the 2nd column will then
be matched against another, new file of phone numbers.
I would prefer a software solution that's free (e.g., download free 30 day trial). |
Clarification of Question by
tmac40-ga
on
11 Jul 2005 20:54 PDT
The matched phone numbers in the 1st column are listed next to another
column of information that classifies each phone number into a
specific group. That's why I need to match the phone numbers. So I
can append this classification information to the phone numbers in
column two.
|
Clarification of Question by
tmac40-ga
on
11 Jul 2005 21:01 PDT
Trying to get the "excel compare" tool that I downloaded to work for me.
|
Request for Question Clarification by
hummer-ga
on
12 Jul 2005 06:51 PDT
Hi tmac40,
Please let me know if either of these work for you -
The Duplicate Master V1.3 (freeware)
http://members.iinet.net.au/~brettdj/
Duplicate Finder (free to try)
http://www.sharewaresoft.com/Duplicate-Finder-for-Microsoft-Excel-download-8957.htm
Regards,
hummer
|
Clarification of Question by
tmac40-ga
on
12 Jul 2005 07:33 PDT
I've tried duplicate finder. I'll check out the other one. Thanks.
|
Request for Question Clarification by
hummer-ga
on
17 Jul 2005 12:41 PDT
Hi tmac40,
I was wondering if you've had a chance to try Duplicate Master yet,
and if so, have you had any luck with it?
Regards,
hummer
|
Clarification of Question by
tmac40-ga
on
18 Jul 2005 07:28 PDT
It didn't work for me. I was able to get a vendor to do this for me.
Thank you!
|
