I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks

In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:
I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thanks for the reponse Debra-

I am still getting the same results...

"Debra Dalgleish" wrote:

In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:
I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Debra's answer is correct.

If the result you are getting is not correct then you are 1. not following
the instructions properly or 2. you are not telling us everything.

Show us a column of data, show us you criteria range, and show us the
results you are getting and the results you want.

1. Suppose the title is in cell D1 and is Code. Then in F1:H1 enter the
word Code in each cell. In F2:H2 enter
<*c* <*d* <*F*
2. Select the range D1:D100 anc choose Data, Filter, Advanced Filter
3. Make sure the List Range is D1:D1000
4. Click in the Criteria Range box and pick F1:H2
5. Click OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Memphus01" wrote:

Thanks for the reponse Debra-

I am still getting the same results...

"Debra Dalgleish" wrote:

In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:
I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thanks Debra and Shane- Here is an example of the layout I have right now.
When I run the fileter I am still showing data that has one of the letters
in the rating

Criteria
<.80 99 <*C*
<.80 99 <*C*
.79 <99 <99 <*C*
<.80 99 <*D*
<.80 99 <*D*
.79 <99 <99 <*D*
<.80 99 <*F*
<.80 99 <*F*
.79 <99 <99 <*F*

Data
81% 150 92 AAB
88% 101 164 AAB
89% 134 59 BAA
82% 155 109 AAB
79% 162 43 AAB
79% 177 121 ACC
92% 102 103 AAA
86% 122 124 DBB
67% 213 50 AAC


"Shane Devenshire" wrote:

Debra's answer is correct.

If the result you are getting is not correct then you are 1. not following
the instructions properly or 2. you are not telling us everything.

Show us a column of data, show us you criteria range, and show us the
results you are getting and the results you want.

1. Suppose the title is in cell D1 and is Code. Then in F1:H1 enter the
word Code in each cell. In F2:H2 enter
<*c* <*d* <*F*
2. Select the range D1:D100 anc choose Data, Filter, Advanced Filter
3. Make sure the List Range is D1:D1000
4. Click in the Criteria Range box and pick F1:H2
5. Click OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Memphus01" wrote:

Thanks for the reponse Debra-

I am still getting the same results...

"Debra Dalgleish" wrote:

In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:
I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

What headings do you have on the Data columns?
You should have the same headins in the criteria range.

Also, all 3 of the letter criteria need to be on the same row, not in
separate rows.

When they're in the same row, the Operator is And, e.g. doen't contain C
AND doesn't contain D AND doesn't contain F

If you have them on separate row, the Operator is OR, which will let
unwanted characters slip through the filter.

Add your headings in the first row of the heading, and three rows of
criteria below, e.g.

Col01 Col02 Col03 Code Code Code
<.80 99 <*C* <*D* <*F*
<.80 99 <*C* <*D* <*F*
.79 <99 <99 <*C* <*D* <*F*


Memphus01 wrote:
Thanks Debra and Shane- Here is an example of the layout I have right now.
When I run the fileter I am still showing data that has one of the letters
in the rating

Criteria
<.80 99 <*C*
<.80 99 <*C*

.79 <99 <99 <*C*

<.80 99 <*D*
<.80 99 <*D*

.79 <99 <99 <*D*

<.80 99 <*F*
<.80 99 <*F*

.79 <99 <99 <*F*


Data
81% 150 92 AAB
88% 101 164 AAB
89% 134 59 BAA
82% 155 109 AAB
79% 162 43 AAB
79% 177 121 ACC
92% 102 103 AAA
86% 122 124 DBB
67% 213 50 AAC


"Shane Devenshire" wrote:


Debra's answer is correct.

If the result you are getting is not correct then you are 1. not following
the instructions properly or 2. you are not telling us everything.

Show us a column of data, show us you criteria range, and show us the
results you are getting and the results you want.

1. Suppose the title is in cell D1 and is Code. Then in F1:H1 enter the
word Code in each cell. In F2:H2 enter
<*c* <*d* <*F*
2. Select the range D1:D100 anc choose Data, Filter, Advanced Filter
3. Make sure the List Range is D1:D1000
4. Click in the Criteria Range box and pick F1:H2
5. Click OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Memphus01" wrote:


Thanks for the reponse Debra-

I am still getting the same results...

"Debra Dalgleish" wrote:


In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:

I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thanks Debra- I can't believe I didn't think about the fact that each filter
was letting the other letters in!



"Debra Dalgleish" wrote:

What headings do you have on the Data columns?
You should have the same headins in the criteria range.

Also, all 3 of the letter criteria need to be on the same row, not in
separate rows.

When they're in the same row, the Operator is And, e.g. doen't contain C
AND doesn't contain D AND doesn't contain F

If you have them on separate row, the Operator is OR, which will let
unwanted characters slip through the filter.

Add your headings in the first row of the heading, and three rows of
criteria below, e.g.

Col01 Col02 Col03 Code Code Code
<.80 99 <*C* <*D* <*F*
<.80 99 <*C* <*D* <*F*
.79 <99 <99 <*C* <*D* <*F*


Memphus01 wrote:
Thanks Debra and Shane- Here is an example of the layout I have right now.
When I run the fileter I am still showing data that has one of the letters
in the rating

Criteria
<.80 99 <*C*
<.80 99 <*C*

.79 <99 <99 <*C*

<.80 99 <*D*
<.80 99 <*D*

.79 <99 <99 <*D*

<.80 99 <*F*
<.80 99 <*F*

.79 <99 <99 <*F*


Data
81% 150 92 AAB
88% 101 164 AAB
89% 134 59 BAA
82% 155 109 AAB
79% 162 43 AAB
79% 177 121 ACC
92% 102 103 AAA
86% 122 124 DBB
67% 213 50 AAC


"Shane Devenshire" wrote:


Debra's answer is correct.

If the result you are getting is not correct then you are 1. not following
the instructions properly or 2. you are not telling us everything.

Show us a column of data, show us you criteria range, and show us the
results you are getting and the results you want.

1. Suppose the title is in cell D1 and is Code. Then in F1:H1 enter the
word Code in each cell. In F2:H2 enter
<*c* <*d* <*F*
2. Select the range D1:D100 anc choose Data, Filter, Advanced Filter
3. Make sure the List Range is D1:D1000
4. Click in the Criteria Range box and pick F1:H2
5. Click OK.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Memphus01" wrote:


Thanks for the reponse Debra-

I am still getting the same results...

"Debra Dalgleish" wrote:


In the criteria range, put the rating column heading in the top 3 cells.
In the 3 cells below, enter criteria to exclude each of the 3 letters.

The criteria range will look like this:

Rating Rating Rating
<*C* <*D* <*F*

Memphus01 wrote:

I am trying to do an advanced filter using data in the rows above my data

i have four columns that I am filtering.

columns A-C contain numeric data and I am not having any issue with those
filters.

column D has a three letter rating system ranging from AAA to FFF (each of
the three letters could be A,B,C,D,F...for example you could have ACA, ABD,
ADD, etc...)

I would like to filter that column for records that does not contain a C,D,
or F.

I tried ="<*C*" (for example) but it is not working.

how can I write that formula so that it looks at all three letters and
excludes any C's,D's,F's?

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com