Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Formula for Text Entries | Excel Worksheet Functions | |||
Detecting Blanks and Non Text Characters. | Excel Worksheet Functions | |||
how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
blank cells that include text | Excel Worksheet Functions |