Filter

[Guest]

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?

 

[Govind]

Hi,

Try Advanced filter.That would serve your purpose.

Govind.

 

[Guest]

As soon as I clicked on advanced filter it automatically switched off the
autofilter function. I need the autofilter to be available on some of the
columns?

 

[Debra Dalgleish]

You could add another column to your table, and use it to check for
occurrences of the code in any column. For example, assuming codes are
in columns B:L --

In cell O1, type the code you want to filter for.
In cell M1, type the heading, "Check"
In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)>0
Copy the formula down to the last row of data
Filter the Check column for TRUE

 

[Guest]

Thanks Debra

It works a treat.

You could add another column to your table, and use it to check for
occurrences of the code in any column. For example, assuming codes are
in columns B:L --

In cell O1, type the code you want to filter for.
In cell M1, type the heading, "Check"
In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)>0
Copy the formula down to the last row of data
Filter the Check column for TRUE

 

[Guest]

THAT'S IT! I've been trying to do pretty much the same sort of filtering
thing, with no luck at all. Your suggestion worked for me perfectly! Thanks!