Thread: Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DP
 
Posts: n/a
Default Filter

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?