+ Reply to Thread
Results 1 to 8 of 8

Advanced filter when column values are "True" and "False"

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010/13
    Posts
    4

    Advanced filter when column values are "True" and "False"

    I recently ran into an issue with some code I was running that used an advanced filter to copy data from one workbook to the other. I assumed it was bad code somewhere but I discovered that manually recreating and executing the advanced filter resulted in the same issue. I am trying to filter on a column that only holds True/False values but it will always return 0 entries. I assume that because the adv filter itself uses True/False, there is some conflict there but I could not find anyone else with the same issue. I'm hoping someone has an easy workaround for this issue. I pasted a simple example below. Thanks!

    Advanced Filter True False.xlsx
    Last edited by cb366374; 03-17-2014 at 10:34 AM. Reason: added workbook example

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Advanced filter when column values are "True" and "False"

    Picture is nice but no one can work on it. Upload a small samplw workbook, pls.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    11-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010/13
    Posts
    4

    Re: Advanced filter when column values are "True" and "False"

    Orginal post is edited to include workbook. Thanks.

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Advanced filter when column values are "True" and "False"

    It's really hard to do exactly like you want. But here is a suggestion.
    Attached Files Attached Files

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Advanced filter when column values are "True" and "False"

    I think that I found the problem. I eliminated the = signs from the AAA and TRUE. When TRUE or FALSE are used as the criteria, they are all upper case. If the True and False in the data are changed to upper case, the filter works.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  6. #6
    Registered User
    Join Date
    11-04-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010/13
    Posts
    4

    Re: Advanced filter when column values are "True" and "False"

    That's a really interesting quirk. Thanks for your responses guys.

    The issue I have is I'm pulling data from another workbook that will always show "True" and "False" with the lowercase letters so it will undoubtedly add some complexity to my code to replace those. The source file is massive so it will add some time to the process if I need to replace all those values each time (about 300k instances of True/False) but thankfully, I control the source file so I could potentially add it to the refresh cycle each morning.

  7. #7
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Advanced filter when column values are "True" and "False"

    Give this a try. Click the "Filter / Unfilter" button.

    You can also use the "*"'s as wildcards so it will pick-up any string with "True" in it.


    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Advanced filter when column values are "True" and "False"

    Thanks for the feedback.

    I also found out that you can use Find and Replace to make the replacements that you need.

+ 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. Replies: 10
    Last Post: 01-26-2012, 08:26 AM
  2. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  3. Setting values for "TRUE","FALSE" and "#REF!"
    By Hurtige in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2006, 07:31 AM
  4. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  5. IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 AM

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