Identify orders containing certain products

Copper Contributor

Hi,

i have a list of Orders and related items.

 

I would like to identify in an easy way only orders containing items A-B-Z (at the same time). So if there's an order containing just A-B should not be identified.

 

How this can be done?

 

Immagine 2022-01-28 180209.png

3 Replies

Hi @AFOfficino 

Using UNIQUE, FILTER and TEXTJOIN will do it;

 

bosinander_0-1643390472259.png

D2. Get the unique order numbers

=UNIQUE(A2:A47)

 

E2 and fill down; join the items to a searchable text

=TEXTJOIN("-";;SORT(FILTER(B1:B47;A1:A47=D2)))

 

Finally, G" filters the order numbers that matches the wanted items.

=FILTER(D2#;OFFSET(D2#;0;1)=G1)

@AFOfficino 

This can be done with Power Query and then filter according to your requirement.

Hi @AFOfficino 

 

Another Power Query option in attachment

 

Screenshot.png