Comments on: Using Advanced Filter in Excel - criteria range examples with formulas

In our previous article, we discussed different aspects of Excel Advanced Filter and how to use it to filter rows with AND as well as OR logic. Now that you know the basics, let's have a look at more complex criteria range examples that may prove helpful for your work. Continue reading →

Comments page 2. Total comments: 38

  1. Hi,
    I am not able to use Advance Filter in which in criteria
    True or False.Please find below Details.
    Last_Name CFS DCK 90+ Total Login_Hrs. Total
    Rashid 120 71 84 275 123.2431402 TRUE
    kumar 45 46 86 177 47.48628049
    Chaudhary 23 52 87 162 25.68597561
    Kumar 124 46 81 251 126.4253049
    Kushwaha 46 56 85 187 48.78658537
    Verma 120 71 84 275 123.2431402
    Singh1 98 63 89 250 101.0541159
    Subhani 126 53 83 262 128.6684451
    kumar 125 30 120 275 127.4009146

    1. Hello everyone,Challanging question for you all (Please understand the issue carefully before answering hapazardly)
      C1:C10 (weight gain)= 1,2,3,4,5,6,7,8,9,10
      A1:A10 Age of child in month) = 11,20,23,40,55,60,32,80,90,95,160
      Now I make class interval for B1:B10 as (0-1)(2-6)(7-12)(13-24)(25-60)(61-168) in F1:F6
      I did: sum age of child meeting (0-1) in B1 which is always showing 0 gram weight increase, for those child who doesnot exist (mistake calculation), want to display empty cell for such case and sum only of there is value in column J. Formulas working fine for the existing child.

      I couldnot localize how to calculate for those rows that donot exist in J and display empty cells in F.
      Again, for reminder: excel is showing 0 gram increase for those child that doesnot exist in my excel sheet.
      I tried 100s of formulas but non of them worked.
      Please suggest same formula for all calculating in all class intervals as mentioned above

  2. Hi Svetlana,

    How can I used Excel 'Advanced Filter' to filter out those rows that contains certain keywords that met multiple criteria?

    Below is the example:
    A B
    1 00 MAG,NET,PIN,POT
    2 01 NET,OIL,RIZ,SAW
    3 02 TAP,WAX,YAM,ZIP

    For instance, I want Excel Advanced Filter to help me filter out those row that contains either OIL or SAW or YAM. How can I achieve this?

    Please advice.

    Thank you.

    Brian

  3. Hi Svetlana
    I have a complicated excel problem and need your help please. It is too long for this space, so I can send you via email once you have replied. That way i can get your email address
    Take Care
    Willie

    1. Hi Willie,

      You can post the details of your problem on our forum, and we will do our best to help you.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)