Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you compare similar spreadsheets to determine a difference? | Excel Discussion (Misc queries) | |||
compare two spreadsheets and identify records that have any change | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) |