How do you compare 2 different spreadsheets for duplication?
 

If you have 2 different excel spreadsheets, they have the same column
headings and you want to compare the 2 (they are both lenghty 279 lines) to
make sure there is no duplication -- what would be the best and most
efficient way to do this?

How do you compare 2 different spreadsheets for duplication?
 

=IF(COUNTIF(Sheet2!$A$2:$A$279,Sheet1!A2)0,"Dupli cate","OK")

"hiziggie" wrote:

If you have 2 different excel spreadsheets, they have the same column
headings and you want to compare the 2 (they are both lenghty 279 lines) to
make sure there is no duplication -- what would be the best and most
efficient way to do this?