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?

Filter
 

Hi,

Try Advanced filter.That would serve your purpose.

Govind.

DP wrote:
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?

Filter
 

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?

"Govind" wrote:

Hi,

Try Advanced filter.That would serve your purpose.

Govind.

DP wrote:
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?

Filter
 

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


DP wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Filter
 

Thanks Debra

It works a treat.

"Debra Dalgleish" wrote:

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


DP wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Filter
 

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!

"Debra Dalgleish" wrote:

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


DP wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html