Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 6 columns in my worksheet which are grouped into 3 pairs of columns.
Columns A, C and E are the current data for a given product and Columns B, D, and F are the previous data. For instance, Column A result for cell 1 is "January" and Column B result for cell 1 is "March". Similarly for the other two sets of columns. What I want to be able to do is filter to just those rows were the current data is different from the previous data. Therefore, I need to filter on Columns A, C, and E to just those rows where Column A is different than Column B, or Column C is different than Column D, or Column E is different than Column F. I can do this individually for Columns A/B, or C/D, or E/F using advanced filter but want to be able to 1) create a macro to do it, and 2) be able to do it using all 3 sets of columns as the criteria. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel how can I filter multiple columns SIMULTANEOUSLY? | Excel Discussion (Misc queries) | |||
Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |