Filtering data

[Thelee72]

How Can I get the data from Column B, which is not existing in Column
?

Example

Column A has :
1
2
3
4
5
6

Column B has:
1
3
5


Result:
2
4

 

[Jason Morin]

You could use an advanced filter:

1. In an open cell (say E15), insert:
=COUNTIF(B:B,A2)=0
2. Select column A & B.
3. Go to Data > Filter > Advanced Filter
4. In the criteria range put:
E14:E15
ensuring that E14 is empty.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther