How do I make a script in Excel to do this?

[Shawn]

I need to compare 3 sets of data. I want to remove the data in common between each and be left with only ones that are unique for a specific data set.

There are close to 8 thousand rows so doing it by hand would take forever.

 

[olds]

"Can I make a script in Excel to do this?"
Obviously not or you wouldn't be asking.

 

[Shawn]

So it's not possible?

 

[olds]

So it's not possible?

It's not possible at this time for YOU to do it.

 

[yuchai]

Would this work?

1. Combine the 3 sets of data, making sure to add an indicator next to each record to identify which set the row of data came from
2. Do a "countif" on the whole set of data for each record to determine if the records have duplicates on a new column
3. Filter that new column on records that have >1 on the countif; remove these rows
4. Unfilter, and break data back into the 3 groups

 

[KidNiki1]

might be better to ask here: http://forums.anandtech.com/forumdisplay.php?f=10

also, i might be able to tell you what function to use if i had a better idea of what you are working with and what you want to see as a result. you can do a simple true false function to just see ones that dont match. but without knowing more i cant help much.

 

[Shawn]

Would this work?

1. Combine the 3 sets of data, making sure to add an indicator next to each record to identify which set the row of data came from
2. Do a "countif" on the whole set of data for each record to determine if the records have duplicates on a new column
3. Filter that new column on records that have >1 on the countif; remove these rows
4. Unfilter, and break data back into the 3 groups

Actually this may be helpful. Thanks.

 

[Shawn]

might be better to ask here: http://forums.anandtech.com/forumdisplay.php?f=10

also, i might be able to tell you what function to use if i had a better idea of what you are working with and what you want to see as a result. you can do a simple true false function to just see ones that dont match. but without knowing more i cant help much.

I've got a bunch of gene names from high throughput sequencing. 3 excel documents each from a different mutant cell line. They are comparing gene expression changes to the wildtype cell line. However I am trying to weed out the genes that have different expression by chance by removing genes which have changed in all 3 independent mutants.

 

[andylawcc]

Would this work?

1. Combine the 3 sets of data, making sure to add an indicator next to each record to identify which set the row of data came from
2. Do a "countif" on the whole set of data for each record to determine if the records have duplicates on a new column
3. Filter that new column on records that have >1 on the countif; remove these rows
4. Unfilter, and break data back into the 3 groups

:thumbsup;

 

[cirrrocco]

Would this work?

1. Combine the 3 sets of data, making sure to add an indicator next to each record to identify which set the row of data came from
2. Do a "countif" on the whole set of data for each record to determine if the records have duplicates on a new column
3. Filter that new column on records that have >1 on the countif; remove these rows
4. Unfilter, and break data back into the 3 groups

sweet!!!

 

[Phanuel]

Erp.. http://extendoffice.com/images/stories/doc-excel/doc-remove-duplicate-row-excel.png