Custom Filter

[cosmicmiami]

I have a column that contains many letters. These are "certification" codes. The column could be any one or several codes.

1 3 4 Htr U T Do Da
3 4 4tmp U Do Da HT T
1 UT TU T

I want to filter for all rows that contain 4 and T (and other combinations).

Can't seem to get this to work.

Thanks.

 

[Claus Busch]

Hi,

Am Tue, 26 Feb 2013 08:33:16 -0800 (PST) schrieb (e-mail address removed):

1 3 4 Htr U T Do Da
3 4 4tmp U Do Da HT T
1 UT TU T

I want to filter for all rows that contain 4 and T (and other combinations).

try:
Data => Filter => Text Filters => Contains => Includes A AND Includes T


Regards
Claus Busch

 

[Claus Busch]

Hi,

Am Tue, 26 Feb 2013 17:47:47 +0100 schrieb Claus Busch:

try:
Data => Filter => Text Filters => Contains => Includes A AND Includes T

sorry, there is a typo:
Includes 4 AND Includes T

Regards
Claus Busch

 

[Cosmic Miami]

Hi,



Am Tue, 26 Feb 2013 17:47:47 +0100 schrieb Claus Busch:







sorry, there is a typo:

Includes 4 AND Includes T



Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

When I do that I am returned all codes that have a T or t in it. I need to be able to isolate the individual codes. I tried putting a quote on the T, "T" and it didn't work.

 

[Claus Busch]

Hi,

Am Tue, 26 Feb 2013 08:52:59 -0800 (PST) schrieb Cosmic Miami:

When I do that I am returned all codes that have a T or t in it. I need to be able to isolate the individual codes. I tried putting a quote on the T, "T" and it didn't work.

then do it with a helper column. Your strings in column A:
=(ISNUMBER(FIND(4,A2))+ISNUMBER(FIND("T",A2))=2)
and filter by true


Regards
Claus Busch

 

[Cosmic Miami]

Hi,



Am Tue, 26 Feb 2013 18:04:36 +0100 schrieb Claus Busch:






or shorter:

=COUNT(FIND({4,"T"},A2))

and filter for 2





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

I don't want to count them, I want to filter.

 

[Ron Rosenfeld]

I don't want to count them, I want to filter.

Follow ALL of Claus' directions. When you filter for "2" on the helper column, what do you see? If you do it correctly, you will see a filtered list containing only those rows that contain both 4 and T in in column A.