autofilter with array of values and multiple criteria

  • hi.,


    I have column with multiple unique values (which will be dynamic, not standard, as the user might enter different values) like following.


    Offwhite - 21091 HGL

    Off White - Off White

    Offwhite - 10858 SF

    10858 SF - 10858 SF

    WPC.


    ex: finish code1 (off white) - finish code2 (21091 HGL)

    finish code2 (21091 HGL) - finish code2 (21091 HGL)

    finish code1 (off white) - finish code3 (10858 SF)

    finish code3 (10858 SF) - finish code3 (10858 SF)


    I would like to filter out as separate ( finishcode1 & finish code2, finish code2 & finish code)

    Offwhite - 21091 HGL

    Off White - Off White


    and the following as separately.


    Offwhite - 10858 SF

    10858 SF - 10858 SF


    and WPC as separately.




    The current code filters, copy the filtered value, creates new sheet and paste the values for the each value in the array of values.


    How to find solution for the above scenario.


    sample.xlsx

  • Hello,


    Just had a look at your sample file... and noticed there are 6 Unique Laminate colors ...


    Does it mean you would need 6 individual sheets ...

    or

    If, there is some kind of grouping, best would be to add a Column with your Unique family types ...


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello again,


    To give you an idea, have added a Type column with 3 random groups ... for your test


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim,


    Thanks for the help. will tryout as advised.

    little bit brief.

    Concept: the panel will be pasted by laminates on both sides ( either same laminates or two different laminates).

    if both laminates (i.e color (21091 HGL -21091 HGL) (except off white - off white combination) are same or the one laminate is of color with combination of Off white( I.e 21091 HGL - Off white),both are grouped in the same new sheet.

    Like that each unique color ( 10858 SF - 10858 SF) & (10858 SF - OFF WHITE) has to be grouped in the new sheet.

    off white - off white combination alone grouped in another new sheet.


    Like this output i am looking out.


    Basically the unique color to be grouped together. (21091 - 21091 & 21091 - offwhite)


    for that i am trying to access the my array variable, convert to text to column, get the unique values, and autofilter based on the unique values and copy them to the sheet. is it correct way to do that?




    .

  • Thanks for your Thanks ... AND for the Like :thumbup:


    Regarding the Type which groups certain laminates ...

    can you think of a formula to help you create these types ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • hi Carim.,


    Thanks!.


    Attached here with the excel file with the details.


    manually we are doing as filter, text filter of 21091 HGL , so it filters out the 21091 HGL- 21091 HGL & Offwhite - 21091 HGL Categories. Then it has been copied to next sheets.


    Like wise - 10858 SF


    the code will be varies for each project, hence it has to be accessed from the array of Column Value, which has choosen,

  • Hello again,


    Obviously you do know extremely well your field ...


    But, to me, it is difficult to understand your grouping rules ...


    The five groups you have added in Column G seem NOT to correspond to the Legend in Columns I and J ...:/

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi.,


    The five groups corresponds to the Column F and not I & J. If you filter Column F as per the image, you can get the groupings.


    I & J i had indicated the name of the laminates. These laminates combine together form a group. Like (Laminate 01 & Laminate 02 ) or ( Laminate 2 & Laminate 02), etc.,


    Hope it will be clear now..

  • Not sure if you are looking for a formula to create the Groups in Column F ... :/


    Meanwhile, attached is your Version 2 file


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi again,


    Sorry for my mistake ... but I knew there was something I did not understand :S


    Attached is your Version 3 file


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi again,


    Attached is your Version 4 file


    The Type column ( Column G ) shows a formula to allow for the grouping you requested.

    This LookUp formula is based on the Reference Table located in the worksheet Type


    Hope this version is in line with all your expectations

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Glad you could solve your problem :)


    Thanks a lot for your Thanks ... AND for the Likes :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • By the way, forgot to tell you that, if you are facing difficulties, when transposing the solution to your real-life workbook ...


    Do not hesitate to come back to the Forum ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)