Quasi 'tag' function with AutoFilter

[SanDiegoSEO]

Hello,

I'd like to 'tag' cells in Excel so that I can autofilter better. I can do this with manually filtering using 'contains' but this is very limited.

Is there a way to do this?

Thanks in advance.

[NBVC]

Put a formula in a helper column that yields a TRUE/FALSE and then filter by that column... you can have many combined tests this way.

[SanDiegoSEO]

NBVC,

Thanks.

Hmm... And, if the helper columns can use a search formula to see if a string is included instead of manually requiring a flag, this might go much faster.

I tried:

=if(search("string",Q53,1)<>1,false,true)

This works, but leaves a VALUE#! ERROR when false. Do you know how to account for this without showing the VALUE#!

[NBVC]

Are you wanting to check if the string "string" is anywhere in cell Q53 or are you wanting to see if Q53 begins with "string".

For the former:

=Isnumber(Search("string",Q53))

For the latter:

=Left(Q53,Len("string"))="string" or Left(Q53,5)="string" (if you want to hard code it).

[SanDiegoSEO]

NBVC,

Awesome...

The former. I needed that function (isnumber) but didn't know it existed. That's perfect. This will do nicely, I think. Thanks!

Dan

[NBVC]

No problem...