Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
<ASK How to add columm more than the default columm IV | Excel Discussion (Misc queries) | |||
Values on 'y' axis - columm chart type | Charts and Charting in Excel | |||
What is the formula for adding up *values! in a columm in exell | Charts and Charting in Excel | |||
Columm sums | Excel Discussion (Misc queries) | |||
(macro, formula,...) To Copy columm in various sheet's | Excel Discussion (Misc queries) |