Filter from 2 Columns (Unique values) in Excel
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
------------------------------------