+ Reply to Thread
Results 1 to 5 of 5

Advanced filtering on text and blanks

  1. #1
    dtencza
    Guest

    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. #2
    Debra Dalgleish
    Guest

    Re: 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. #3
    dtencza
    Guest

    Re: 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. #4
    Aussie CPA
    Guest

    Re: 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. #5
    Debra Dalgleish
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1