+ Reply to Thread
Results 1 to 2 of 2

How to ignore Autofilter if cell reference value is blank

  1. #1
    Registered User
    Join Date
    11-30-2016
    Location
    Dubai
    MS-Off Ver
    2010
    Posts
    3

    How to ignore Autofilter if cell reference value is blank

    I am trying to filter and extract data from Sheet"Data" depending upon multiple criteria entered in a separate Sheet"Filters". However, as some of the criteria fields in Sheet"Filters" are empty, the data returned is empty. If there a way to ignore if one of the criteria entered is empty and continue with data filtering with other criteria and return data? The following is the code I wrote so far:
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    11-30-2016
    Location
    Dubai
    MS-Off Ver
    2010
    Posts
    3

    Re: How to ignore Autofilter if cell reference value is blank

    Quote Originally Posted by NielPot View Post
    I am trying to filter and extract data from Sheet"Data" depending upon multiple criteria entered in a separate Sheet"Filters". However, as some of the criteria fields in Sheet"Filters" are empty, the data returned is empty. If there a way to ignore if one of the criteria entered is empty and continue with data filtering with other criteria and return data? The following is the code I wrote so far:
    Please Login or Register  to view this content.
    This has been answered in :
    https://stackoverflow.com/questions/...99786#46999786

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Ignore blank cells with formulas or ignore NA() in a formula
    By guiismiti in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-24-2016, 02:13 PM
  2. [SOLVED] If Cell is blank, ignore formula and cell = blank
    By AndrewBa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2014, 05:08 PM
  3. [SOLVED] IF cell is blank ignore if not put over due is before today
    By Ju1cy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 06:56 AM
  4. [SOLVED] Autofilter with multiple criteria - how to ignore blank criteria
    By MOONDRIFT47 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2012, 12:20 PM
  5. [SOLVED] How to ignore a blank cell
    By TamTurner in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2012, 12:48 PM
  6. [SOLVED] Can Autofilter Ignore Blank Criteria?
    By RogueArchon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2012, 01:20 PM
  7. How? Ignore cell if blank in an IF formula.
    By n2lectual in forum Excel General
    Replies: 7
    Last Post: 03-26-2008, 03:46 PM

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