Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm having a challenge with an Advanced Filter; specifically the criteria.

    I have attached a sample file with the expected results highlighted in green.

    Thanks for taking a look,
    John
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Set your criteria to only F1:F2

    F1 should be blank (since F2 will have a formula)
    F2 should have:
    =NOT(ISBLANK(B2))

    Steve

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='sdckapr' post='797183' date='09-Oct-2009 15:30']Set your criteria to only F1:F2

    F1 should be blank (since F2 will have a formula)
    F2 should have:
    =NOT(ISBLANK(B2))

    Steve[/quote]

    Hi Steve,

    I tried your suggestion without success. The end result of your suggestion lists all the items and does not pare down the information to what I have highlighted in green.

    Regards,
    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You probably haven't followed Steve's instructions entirely correctly. See the attached version.
    Attached Files Attached Files

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='797203' date='09-Oct-2009 17:50']You probably haven't followed Steve's instructions entirely correctly. See the attached version.[/quote]


    Sorry, my error as I did not leave F1 blank as instructed by Steve. All is well.

    Thanks Steve and Hans,
    John

Posting Permissions

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