| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it possible to combine data sets, eliminating duplicates?
I'm trying to combine two extensive columns of data, to only look at
the number NOT in BOTH sets. Does anyone know of a way to do this in excel? Basically we need the data that is the DIFFERENCE between the two columns. Any suggestions? Thanks. -wayne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is it possible to combine data sets, eliminating duplicates?
Hi
Assuming your data is in column A and column B. In column D enter in D1 =IF(COUNTIF(B:B,A1),"",A1) in E1 =IF(COUNTIF(A:A,B1),"",B1) Copy down for the extent of data in each column -- Regards Roger Govier wrote in message oups.com... I'm trying to combine two extensive columns of data, to only look at the number NOT in BOTH sets. Does anyone know of a way to do this in excel? Basically we need the data that is the DIFFERENCE between the two columns. Any suggestions? Thanks. -wayne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find date duplicates Col 2 or Col 3 then combine Col 1 text | Excel Worksheet Functions | |||
| I want to combine 2 workbook data bases and remove duplicates | Excel Discussion (Misc queries) | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| combine row and the delete duplicates | Excel Discussion (Misc queries) | |||
| How to combine two data sets with one category of variable in com. | New Users to Excel | |||
Hybrid Mode
