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?