| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
