software

Hi everyone

Is there a way I can filter on multiple columns?

For example, my worksheet has several quot;codequot; columns. The same code may
appear somewhere in all of the quot;codequot; 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?

Hi,

Try Advanced filter.That would serve your purpose.

Govind.

DP wrote:
gt; Hi everyone
gt;
gt; Is there a way I can filter on multiple columns?
gt;
gt; For example, my worksheet has several quot;codequot; columns. The same code may
gt; appear somewhere in all of the quot;codequot; columns. I need the ability to be able
gt; to filter on all the columns.
gt;
gt; I realise Autofilter is not the answer, however, I have to have autofilter
gt; switched on so that I can filter on the rest of the columns in the usual way.
gt;
gt; So what I'm really looking for is the ability to have autofilter on columns
gt; A - J and then some other type of filter to give me the ability to filter on
gt; columns K - P simultaneously.
gt;
gt; Is this possible?

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?

quot;Govindquot; wrote:

gt; Hi,
gt;
gt; Try Advanced filter.That would serve your purpose.
gt;
gt; Govind.
gt;
gt; DP wrote:
gt; gt; Hi everyone
gt; gt;
gt; gt; Is there a way I can filter on multiple columns?
gt; gt;
gt; gt; For example, my worksheet has several quot;codequot; columns. The same code may
gt; gt; appear somewhere in all of the quot;codequot; columns. I need the ability to be able
gt; gt; to filter on all the columns.
gt; gt;
gt; gt; I realise Autofilter is not the answer, however, I have to have autofilter
gt; gt; switched on so that I can filter on the rest of the columns in the usual way.
gt; gt;
gt; gt; So what I'm really looking for is the ability to have autofilter on columns
gt; gt; A - J and then some other type of filter to give me the ability to filter on
gt; gt; columns K - P simultaneously.
gt; gt;
gt; gt; Is this possible?
gt;

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, quot;Checkquot;
In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)gt;0
Copy the formula down to the last row of data
Filter the Check column for TRUEDP wrote:
gt; Hi everyone
gt;
gt; Is there a way I can filter on multiple columns?
gt;
gt; For example, my worksheet has several quot;codequot; columns. The same code may
gt; appear somewhere in all of the quot;codequot; columns. I need the ability to be able
gt; to filter on all the columns.
gt;
gt; I realise Autofilter is not the answer, however, I have to have autofilter
gt; switched on so that I can filter on the rest of the columns in the usual way.
gt;
gt; So what I'm really looking for is the ability to have autofilter on columns
gt; A - J and then some other type of filter to give me the ability to filter on
gt; columns K - P simultaneously.
gt;
gt; Is this possible?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks Debra

It works a treat.

quot;Debra Dalgleishquot; wrote:

gt; You could add another column to your table, and use it to check for
gt; occurrences of the code in any column. For example, assuming codes are
gt; in columns B:L --
gt;
gt; In cell O1, type the code you want to filter for.
gt; In cell M1, type the heading, quot;Checkquot;
gt; In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)gt;0
gt; Copy the formula down to the last row of data
gt; Filter the Check column for TRUE
gt;
gt;
gt; DP wrote:
gt; gt; Hi everyone
gt; gt;
gt; gt; Is there a way I can filter on multiple columns?
gt; gt;
gt; gt; For example, my worksheet has several quot;codequot; columns. The same code may
gt; gt; appear somewhere in all of the quot;codequot; columns. I need the ability to be able
gt; gt; to filter on all the columns.
gt; gt;
gt; gt; I realise Autofilter is not the answer, however, I have to have autofilter
gt; gt; switched on so that I can filter on the rest of the columns in the usual way.
gt; gt;
gt; gt; So what I'm really looking for is the ability to have autofilter on columns
gt; gt; A - J and then some other type of filter to give me the ability to filter on
gt; gt; columns K - P simultaneously.
gt; gt;
gt; gt; Is this possible?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

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!

quot;Debra Dalgleishquot; wrote:

gt; You could add another column to your table, and use it to check for
gt; occurrences of the code in any column. For example, assuming codes are
gt; in columns B:L --
gt;
gt; In cell O1, type the code you want to filter for.
gt; In cell M1, type the heading, quot;Checkquot;
gt; In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)gt;0
gt; Copy the formula down to the last row of data
gt; Filter the Check column for TRUE
gt;
gt;
gt; DP wrote:
gt; gt; Hi everyone
gt; gt;
gt; gt; Is there a way I can filter on multiple columns?
gt; gt;
gt; gt; For example, my worksheet has several quot;codequot; columns. The same code may
gt; gt; appear somewhere in all of the quot;codequot; columns. I need the ability to be able
gt; gt; to filter on all the columns.
gt; gt;
gt; gt; I realise Autofilter is not the answer, however, I have to have autofilter
gt; gt; switched on so that I can filter on the rest of the columns in the usual way.
gt; gt;
gt; gt; So what I'm really looking for is the ability to have autofilter on columns
gt; gt; A - J and then some other type of filter to give me the ability to filter on
gt; gt; columns K - P simultaneously.
gt; gt;
gt; gt; Is this possible?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;