Advanced filtering on text and blanks
 

I have a list where one field has days of the week ("Sunday", "Monday", etc.)
in text. So, I can use the Advanced Filter with different rows that have
"Monday" or "Tuesday" to return all of the records that have "Monday" or
"Tuesday" in this field.

What if I wanted to use the advanced filter to get records that have
"Monday", "Tuesday", or BLANK (no value)? How do I tell the advanced filter
that I'd also like records that have a blank in this field returned as well?

This is easy with the AutoFilter; I just can't figure it out with the
advanced filter!

Advanced filtering on text and blanks
 

In the third criteria cell, enter: ="="

Weekday
Monday
Tuesday
="="

After you press Enter, only the = will be displayed.

dtencza wrote:
I have a list where one field has days of the week ("Sunday", "Monday", etc.)
in text. So, I can use the Advanced Filter with different rows that have
"Monday" or "Tuesday" to return all of the records that have "Monday" or
"Tuesday" in this field.

What if I wanted to use the advanced filter to get records that have
"Monday", "Tuesday", or BLANK (no value)? How do I tell the advanced filter
that I'd also like records that have a blank in this field returned as well?

This is easy with the AutoFilter; I just can't figure it out with the
advanced filter!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Advanced filtering on text and blanks
 

Thanks, Debra! That worked exactly as I needed it to!! :)

"Debra Dalgleish" wrote:

In the third criteria cell, enter: ="="

Weekday
Monday
Tuesday
="="

After you press Enter, only the = will be displayed.

dtencza wrote:
I have a list where one field has days of the week ("Sunday", "Monday", etc.)
in text. So, I can use the Advanced Filter with different rows that have
"Monday" or "Tuesday" to return all of the records that have "Monday" or
"Tuesday" in this field.

What if I wanted to use the advanced filter to get records that have
"Monday", "Tuesday", or BLANK (no value)? How do I tell the advanced filter
that I'd also like records that have a blank in this field returned as well?

This is easy with the AutoFilter; I just can't figure it out with the
advanced filter!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Advanced filtering on text and blanks
 

Debra,
Is there a way to do this for Non-blanks also?


"Debra Dalgleish" wrote:

In the third criteria cell, enter: ="="

Weekday
Monday
Tuesday
="="

After you press Enter, only the = will be displayed.

dtencza wrote:
I have a list where one field has days of the week ("Sunday", "Monday", etc.)
in text. So, I can use the Advanced Filter with different rows that have
"Monday" or "Tuesday" to return all of the records that have "Monday" or
"Tuesday" in this field.

What if I wanted to use the advanced filter to get records that have
"Monday", "Tuesday", or BLANK (no value)? How do I tell the advanced filter
that I'd also like records that have a blank in this field returned as well?

This is easy with the AutoFilter; I just can't figure it out with the
advanced filter!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Advanced filtering on text and blanks
 

You could use the criteria: ="<"

Aussie CPA wrote:
Debra,
Is there a way to do this for Non-blanks also?


"Debra Dalgleish" wrote:


In the third criteria cell, enter: ="="

Weekday
Monday
Tuesday
="="

After you press Enter, only the = will be displayed.

dtencza wrote:

I have a list where one field has days of the week ("Sunday", "Monday", etc.)
in text. So, I can use the Advanced Filter with different rows that have
"Monday" or "Tuesday" to return all of the records that have "Monday" or
"Tuesday" in this field.

What if I wanted to use the advanced filter to get records that have
"Monday", "Tuesday", or BLANK (no value)? How do I tell the advanced filter
that I'd also like records that have a blank in this field returned as well?

This is easy with the AutoFilter; I just can't figure it out with the
advanced filter!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html