+ Reply to Thread
Results 1 to 2 of 2

Advanced Filter to show all Results, even Rows with Multiple Blank Cells

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    1

    Advanced Filter to show all Results, even Rows with Multiple Blank Cells

    I am trying to figure a way out to make advanced filter work by displaying results which has blank in them.

    Currently, my advanced filter will only show results which are complete (rows which do not have any blank cells in them). I understand that you can use ="=" in the cell to showcase blank cell but for criterias which I leave blank, I would like my advanced filter's results to showcase both the blank results as well as results with answers.

    For example:
    I have these as my raw data:

    F Name L Name Order Qty BirthPlace
    John 1111Wood 11111 1111Texas
    Pete 1111Silva 111112 11111NY
    Jim 1111Fox 1111111111111BF
    Marc 111Phillips 11112 111Las Vegas
    Louis 111Tyler 1111115 1111BF

    When I input my criteria for BirthPlace to be "BF", only Louis Tyler will show up as his is a complete set but Jim Fox has a blank and thus he will not show up.

    Any idea on what i can tweak in my formula to make the blanks i.e Jim Fox show up?

    My current code is a simple one:

    Sub GenerateData()
    '
    ' GenerateData Macro
    '


    Sheets("Sheet1").Range("A1:Q3530").AdvancedFilter Action:=xlFilterCopy, _
    CriteriaRange:=Range("C11:Q12"), CopyToRange:=Range("B14:R14"), Unique:= _
    False
    ActiveWindow.ScrollColumn = 1
    EndSub




    Thank you!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Advanced Filter to show all Results, even Rows with Multiple Blank Cells

    You forgot the code tags and please attach a Excel sample file
    - Battle without fear gives no glory - Just try

+ 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] VBA Advanced Filter - Keep Blank Rows and put them at the top
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 03:22 PM
  2. Ignoring Blank Cells - Advanced Filter
    By ayvee0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 05:23 PM
  3. Advanced filter with blank cells / Dynamic named range with blank cells
    By Jason_2112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2010, 12:06 PM
  4. Advanced filter finding blank cells
    By Nigel in forum Excel General
    Replies: 1
    Last Post: 02-05-2010, 09:54 AM
  5. Advanced Filter to return Rows w/blank column
    By ChemistB in forum Excel General
    Replies: 3
    Last Post: 04-01-2009, 01:14 PM
  6. Advanced Filter - Blank Rows
    By karl_009 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2008, 06:35 AM
  7. [SOLVED] How do I use advanced filter to filter for blank cells?
    By Monique in forum Excel General
    Replies: 2
    Last Post: 03-21-2006, 02:45 PM

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