Autofilter using dynamic array with filtersets

[sekar]

Hi.,
i have the following set of filter range.

Laminte

F322_Baker-11065_SF

11065_SF-11065_SF

11065_SF-21091_SF

F322_Baker-25879_SF

25879_SF-25879_SF

25879_SF-21091_SF

F322_Baker-45693_SF

45693_SF-45693_SF

45693_SF-21091_SF

each line represent the materials F322_backer is one mateiral, 11065_SF is another material. the range is the combination of the materials.
1. The range might not be in this order, but it has to be grouped like this. preference of order is not necessary.

i.e starting with F322_baker - with any other material (ex:11065_SF or 25879_SF)
2. the combination of same material (i,.e other mateiral - 11065_SF) done in the first point (like this: 11065_SF-11065_SF)
3. Other material (11065_SF) with any other material 1(21091_SF) present, if more than any other material 2 then Other material (11065_SF) with any other material 2

once this has been ordered, want to first create a filter set based on each group
Group1

F322_Baker-11065_SF

11065_SF-11065_SF

11065_SF-21091_SF

Group 2

F322_Baker-25879_SF

25879_SF-25879_SF

25879_SF-21091_SF

Group 3

F322_Baker-45693_SF

45693_SF-45693_SF

45693_SF-21091_SF

After filter set is created, each filterset is applied for autofilter and the values are copied. to a sheet.
can any one help on this

 

[Akuini]

i.e starting with F322_baker

So, in the result, each group always begin with "F322_baker"?

1. The range might not be in this order, but it has to be grouped like this. preference of order is not necessary.

How do you mean? data could be in any order? for example like this:

11065_SF-11065_SF

11065_SF-21091_SF

25879_SF-21091_SF

25879_SF-25879_SF

45693_SF-21091_SF

45693_SF-45693_SF

F322_Baker-11065_SF

F322_Baker-25879_SF

F322_Baker-45693_SF

3. Your example make it looks like you just want to create groups with just 1 criteria which is begin with "F322_baker". Could you provide a more representative example to show what the problem is?

 

[sekar]

hi @Akuini

So, in the result, each group always begin with "F322_baker"?

Yes

How do you mean? data could be in any order? for example like this:

Yes

3. Your example make it looks like you just want to create groups with just 1 criteria which is begin with "F322_baker". Could you provide a more representative example to show what the problem is?

i.e starting with F322_baker - with any other material (ex:11065_SF or 25879_SF)
2. the combination of same material (i,.e other mateiral - 11065_SF) done in the first point (like this: 11065_SF-11065_SF)
3. Other material (11065_SF) with any other material 1(21091_SF) present, if more than any other material 2 then Other material (11065_SF) with any other material 2

we have multiple laminates in the data. each board is finished with two laminates (F322 baker, 11065_SF,21091_SF,25879_SF,45693_SF, etc.,)

The data has to be ordered for each finish or laminates. Hope you can understand better now.
So the criteria is to filter out for example referring the below image , first one finish ex: 21003 HGL,

Group 1 ( Filtered Set 1)
First criteria., (considering the material is 21003_HGL)
starting with F322_baker -21003 HGL

second criteria.,

the combination of same material use in the first criteria, (i,.e :21003 HGL_:21003 HGL)

Third Criteria.,
21003_HGL -3701 SLG

LIke wise for each group ( filtered set) each material is used in the above three criteria

 

[Akuini]

i have the following set of filter range.

So, the example in post 1 is a filtered range?

I still don't understand your data, the example in the last post is more complicated. Could you please upload a sample workbook to a file-sharing site like Dropbox or Google Drive and share the link here? Also, ensure that the link is accessible to anyone. If there is sensitive data, please replace it with representative dummy data. And please also provide the expected results.

 

[sekar]

hi.,
i had uploaded the file over here

Loading Google Sheets

The first sheet is named as Full List with reference column Laminate Code (column I), where finishes are mentioned.

You can refer these sheets

If you refer 3582 SLG Sheet,

the first set of data is F322 Baker / 3582 SLG (18 mm thk)
the second set is F322 Baker / 3582 SLG (3.5mm Thick),
the third set is 3582 SLG /3582 SLG (18mm thk)
the fourth set is 3582 SLG /3582 SLG (27mm thk)

The data is in the Sheet Named Full List, rest of the sheets are output by filtering the sets from the data sheet.

Hope now it is clear.
If you have any queries let me know.

 

[Akuini]

I have downloaded your workbook. Regrettably, I am still unable to comprehend your data and your requirements, as it appears to be more intricate than I initially anticipated. Therefore, I will step back from this thread, and I hope someone else may be able to assist you.