How can I filter just 2 columns (separated by another column)?

T

theglove33

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
 
J

John C

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'.
 
G

Gord Dibben

When you filter on any column, rows from all columns are hidden.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to center adjust text above and image in a two column document. 1
Format column widths from one table to a separate table on same page 1
Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Unique Records in Column 3
Two columns : Continuous two columns vs Parallel two Column 1
VBA Macro to unfilter specific column 1

Top