Excel Spreadsheet

[matrixcl55]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hey Guys,

New to the group. I have an Excel spreadsheet question. I have two spread sheets or files with names and phone numbers on both spreadsheets/files. I need to compare/identify the names on sheet (1) to the names on sheet (2) to ascertain if I have duplicate entries. Is there a simple way or macro for sorting the two files?

Thanks,
J. Brooks

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hey Guys,

New to the group. I have an Excel spreadsheet question. I have two spread
sheets or files with names and phone numbers on both spreadsheets/files. I
need to compare/identify the names on sheet (1) to the names on sheet (2) to
ascertain if I have duplicate entries. Is there a simple way or macro for
sorting the two files?

There are many ways to accomplish this. One way:

Assume the names in the 2 workbooks are each in sheet1, column A. Then
enter this in an empty column (say, J1)

=IF(COUNTIF([Workbook1]Sheet1!$A:$A, A1)>0,"Duplicate","")

Copy down as far as necessary.