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