| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I filter just 2 columns (separated by another column)?
Hi. Does anyone know how to filter just two columns?
For example, I want to filter column B and column D only. No other columns. Thoughts? TIA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I filter just 2 columns (separated by another column)?
If your data is in columns A through D, but you only want B & D filtered, are
you saying that you still want all the data in A & C visible? You realize that the data in the rows would no longer 'match up'. -- John C "theglove33" wrote: Hi. Does anyone know how to filter just two columns? For example, I want to filter column B and column D only. No other columns. Thoughts? TIA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I filter just 2 columns (separated by another column)?
When you filter on any column, rows from all columns are hidden.
Gord Dibben MS Excel MVP On Tue, 29 Jul 2008 11:05:01 -0700, theglove33 wrote: Hi. Does anyone know how to filter just two columns? For example, I want to filter column B and column D only. No other columns. Thoughts? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif w/semicolon separated values AND Filter | Excel Worksheet Functions | |||
| Combining separated columns? | Charts and Charting in Excel | |||
| How do I create two columns from one column (space separated info | Excel Worksheet Functions | |||
| How to filter 7 columns in a 20 column spreadsheet? | Excel Worksheet Functions | |||
| Copy/Paste of separated columns | Excel Discussion (Misc queries) | |||
Linear Mode
