Excel Spreadsheet

M

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
 
J

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?
Click to expand...


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.
 
Top