Excel 2007 filtering 1

[mufka]

I have two columns. Column 1 contains the values 1, 2, 3, 4, 5. Column 2 contains the values 4, 5, 6, 7, 8, 9. Is there a way to filter into a third column just the values that are not found in both columns? i.e. 1, 2, 3, 6, 7, 8, 9.

 

[tav1035]

Here is the wildest way that I can think of...

Insert a Column before Column1
add this formula =IF(ISERROR(MATCH(B2,C:C,0)),B2,"")
Insert a Column after Column2
add this formula =IF(ISERROR(MATCH(C2,B:B,0)),C2,"")
Pull both of those formulas all the way down.

Now filter on "non blanks" in column1 and that data is unique.
Then
Unfilter column1 and filter column4 for "non blanks" and that data is unique.
tav

 

[SkipVought]

Hi,

in column C
[tt]
C2: =COUNTIF(A:A,B2)
[/tt]
and copy thru all cells with data in column B.

any column B value that appears in column A will have a column C value greater than 0.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}