+ Reply to Thread
Results 1 to 3 of 3

Need to Autofilter by date and include blank cells

  1. #1
    Registered User
    Join Date
    11-04-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Need to Autofilter by date and include blank cells

    So I have a spreadsheet that tracks computer equipment that is shipped out, and for each piece of shipped equipment (1 per row) an equivalent piece of equipment is returned to us. Each piece of return equipment is marked in the "date returned" column K.

    I would like to set the autofilter options for column F to show only rows that have either:

    A) A return date of the last 4 weeks
    B) No return date at all

    This will show me only rows with recently returned equipment, or equipment with pending returns.

    I expected that I would be able to achieve this through customer filters by specifying:

    "is after or equal to today-28" OR
    "equal to <blank>"

    So far I'm not having any luck, the autofilter box doesn't seem to respond to 'today-28'. Anyone know a way to achieve this?
    Last edited by Jigsaw314; 11-05-2012 at 08:02 PM. Reason: Solved

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Need to Autofilter by date and include blank cells

    probably the easiest way of doingthis is to add a helper column, and use a formula, something like...

    =if(or(K1="",K1<=today()),"OK","")

    and then filter on OK (you can use whatever you want instead of OK, as well as for the ""
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-04-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need to Autofilter by date and include blank cells

    Thanks for your prompt help

    I added a helper column called 'Archive' and set autofilter to hide rows containing YES. I tweaked the code a little and now it works perfectly:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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