Thread: How do you compare 2 different spreadsheets for duplication?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nobody Nobody is offline
external usenet poster
  
Posts: 47
Default 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?

Reply With QuoteReply With Quote