View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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