compare massive values of data in excel

[Guest]

HI all, the list I am working on consist of phone number, date, conversation
start time, conversation end time.

and there around 3476 records in one file and 2477 records in another...

and they are not in the same format...

so what I did was to sort out all the relative infomation in one file by its
phone number, and did the same for the other one

then I copy and pasted both lists in a new file.. and did the above
comparesion.. nothing showed up or just gives me errors..


I am doing some analysis for our datebase records...... the sample I took
out is only the small part.. the real file is like 34 MB each...


BTW if you know how to make a whole set of value appear all together please
help


for example:


I have in one excel file

Date_________Start time_________End time___________Phone Number
7/2/04_______5:30______________5:35_______________1987654321
7/2/04_______5:36______________5:39_______________1564523123
7/2/04_______5:39______________5:40_______________1987654321
7/2/04_______5:31______________5:35_______________1546456133
7/2/04_______5:34______________5:35_______________1879456321
7/2/04_______5:36______________5:38_______________1451313226
7/2/04_______5:34______________5:35_______________1987654321
7/2/04_______5:37______________5:39_______________1785465453445( yes some
phone number has more digits than others)




another one that are similar, but the start time and ending time is
different, but some of the numbers are the same

Date_________Start time_________End time___________Phone Number
7/2/04_______5:34______________5:39_______________1987654321
7/2/04_______5:39______________5:42_______________15645453535
7/2/04_______5:32______________5:42_______________1535242425
7/2/04_______5:23______________5:26_______________1546456133
7/2/04_______5:44______________5:45_______________187453445
7/2/04_______5:36______________5:45_______________1454353535335
7/2/04_______5:34______________5:55_______________1987654321
7/2/04_______5:37______________5:56_______________1785465453445


What I want to do is sort out the files by the phone number (which I did)
Then copy past both sets of information into one big file for analysis and
the final result should be something like
Date_________Start time_________End time___________Phone Number
7/2/04_______5:34______________5:39_______________1987654321
7/2/04_______5:30______________5:35_______________1987654321

7/2/04_______5:31______________5:35_______________1546456133
7/2/04_______5:23______________5:26_______________1546456133

7/2/04_______5:37______________5:56_______________1785465453445
7/2/04_______5:37______________5:39_______________1785465453445

7/2/04_______5:34______________5:55_______________1987654321
7/2/04_______5:34______________5:35_______________1987654321

and then in a different column dispaly all the phone numbers that did not
appear on both lists...

for ex:
7/2/04_______5:36______________5:39_______________1564523123
7/2/04_______5:39______________5:42_______________15645453535
........



so far I am looking at the option of going through both lists one phone at a
time.. that's gonna take forever ...

Thx for the help

 

[Jerry W. Lewis]

Why not put the phone number in a separate column for each set, then use
=MATCH(number,otherList,0)
to determine whether a given number is in the other list. Unique
numbers would produce #N/A results.

Jerry