Check out some similar questions!

manjunathputtabuddi · Feb 13, 2007, 07:46 AM

I need to filter from both these sets of data in excel

Set 1 Set 2
-----------------------
986 Buchanan
Dodsworth 563
67 789
Buchanan 235
689 Dodsworth
789 143
56 237

the values in each set will be unique and no duplicates and set1 and set2 might have same values, I want to filter the values which is unique from both,
I have Countif, Sumif and other formulae's but invain, Please help me if u have any tips
Thanks in advance.

Manjunath.P
[email protected]
98459 64454
------------------------------------

ScottGem · Feb 13, 2007, 07:50 AM

Ok, so you are saying that you want all rows where the value in SET1 doesn't appear in Set 2 and vice versa?

I would use the Query builder to do this. You want to build a SQL query like:

SELECT Set1 FROM table WHERE Set1 Not In(SELECT Set2 FROM table);