Forum Discussion
Identify orders containing certain products
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?
3 Replies
This can be done with Power Query and then filter according to your requirement.
Hi AFOfficino
Using UNIQUE, FILTER and TEXTJOIN will do it;
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)
