Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi everyone
Is there a way I can filter on multiple columns? For example, my worksheet has several "code" columns. The same code may appear somewhere in all of the "code" columns. I need the ability to be able to filter on all the columns. I realise Autofilter is not the answer, however, I have to have autofilter switched on so that I can filter on the rest of the columns in the usual way. So what I'm really looking for is the ability to have autofilter on columns A - J and then some other type of filter to give me the ability to filter on columns K - P simultaneously. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |