Filter: one columm different from another
 

XLS 2007

On a range I applied a filter. Now I want to see only the rows where
column A is different from column B

How do I do this?

Thank you

Filter: one columm different from another
 

I'd insert a new column (column C) and use a formula like:

=a2=b2
(and copy down)

Then filter to show the False's.

vsoler wrote:

XLS 2007

On a range I applied a filter. Now I want to see only the rows where
column A is different from column B

How do I do this?

Thank you

--

Dave Peterson

Filter: one columm different from another
 

On 8 ago, 15:18, Dave Peterson wrote:
I'd insert a new column (column C) and use a formula like:

=a2=b2
(and copy down)

Then filter to show the False's.

vsoler wrote:

XLS 2007

On a range I applied a filter. Now I want to see only the rows where
column A is different from column B

How do I do this?

Thank you

--

Dave Peterson

Thank you Dave, but I am looking for a solution without extra columns,
using just the range that I have and the filters. Do you think that it
is possible to get to the desired result?

Filter: one columm different from another
 

You can do it with advanced filter

http://www.contextures.com/xladvfilter02.html#Unmatched


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"vsoler" wrote in message ...
On 8 ago, 15:18, Dave Peterson wrote:
I'd insert a new column (column C) and use a formula like:

=a2=b2
(and copy down)

Then filter to show the False's.

vsoler wrote:

XLS 2007

On a range I applied a filter. Now I want to see only the rows where
column A is different from column B

How do I do this?

Thank you

--

Dave Peterson

Thank you Dave, but I am looking for a solution without extra columns,
using just the range that I have and the filters. Do you think that it
is possible to get to the desired result?

Filter: one columm different from another
 

Hi,

Insert a new column (column C).

In cell C2 put: =IF(A2=B2,"Yes","No").
Note: you can change Yes (if the result is true) and No (if the result is
false) as you like.

Copy/Dropdown C2 to fill all the data in Column A and B.

Thin sort/filter Column C, now you can check it.

--
MFS22


"vsoler" wrote:

XLS 2007

On a range I applied a filter. Now I want to see only the rows where
column A is different from column B

How do I do this?

Thank you