Filtering subject to another column

  • Thread starter Thread starter David Morrison
  • Start date Start date
D

David Morrison

I have three columns as follows. I'd like to filter columns 1 and 2 such
that the only values returned are those where the values in column 2 are in
column 3.

Example:

Before filter
New Account
Map To
Old Account

11111-202-00-000-0000
01-14300-202-0000-0
01-14300-202-0000-0

11111-203-00-000-0000
01-14300-203-0000-0
01-14300-203-0000-0

11150-000-00-000-0000
01-14355-000-0000-0
01-20135-000-0000-0

11150-202-00-000-0000
01-14355-202-0000-0
01-20135-202-0000-0



Desired result after filter
New Account
Map To
Old Account

11111-202-00-000-0000
01-14300-202-0000-0
01-14300-202-0000-0

11111-203-00-000-0000
01-14300-203-0000-0
01-14300-203-0000-0



01-20135-000-0000-0



01-20135-202-0000-0
 
To do this with an AutoFilter, add a column to check if the values are
equal. For example, in cell D1, enter the heading "Same".
In cell D2, enter the formula, =C2=B2
and copy the formula down to the last row of data
Filter column D for TRUE.

Or, use an Advanced Filter. There are instructions here for an Advanced
Filter:

http://www.contextures.com/xladvfilter01.html

Set up a criteria area with a blank heading cell, and in the cell below,
enter the formula: =C2=B2
 
Back
Top