Sep 27 2022 02:29 PM
Hi
I have been given a task at work.
I have a 3 column table of sales orders products and quantities to produce.
I need a identify the products from there unique value which may appear multiple times in the column.
A product can be identified from its 3 and forth character eg
xx23xxx indicates it’s a 23 inch box.
there is xx93xx which is a 93 inch box etc
I need identity all the times 23 inches box appears and count the quantity that need to be produced.
What formula do I need.. match and count?
Help is require. I will give a screen dump tomorrow if need be. Thanks
Sep 27 2022 02:58 PM
How about
= LET(
size, CONCATENATE("*",MID(products,3,2),"*"),
distinct, UNIQUE(size),
SUMIFS(quantities, products, distinct)
)