Advanced Filter: Does Not Equal Text

[Texas Longhorn]

This seems like a simple question, but I haven't found anything in Excel help or in searching the forum...

I have a list that I run an advanced filter on. One of the columns (E) has the heading "TYPE". In the column, most rows are blank, some say "RENEWAL" and some say "CAMPUS".

What is the syntax in E2 for Does Not Equal Renewal? Or do I have to do two criteria, ="=" and ="=CAMPUS"?

Thanks.

 

[north19701]

Have you tried <>Renewal?

 

[Texas Longhorn]

Yes, I had, and it didn't work. Of course, when I tried it again, it did. I must have thrown in a space or something. Clearly, it's Monday.

Thanks.

 

[Aladin Akyurek]

Try the following which also eliminates empty cells...

Book13
	D	E	F	G	H
1		Type
2		RENEWAL		FALSE
3				Type
4		CAMPUS		CAMPUS
5		ZXA		ZXA
6
7		RENEWAL
8
Sheet1

The formula in G2 in the Criteria range G1:G2 is:

=AND(E2<>"RENEWAL",E2<>"")