product1

Hi Hard to explain this one. In sheet 1 i have a list of products in Column A Product1 Product2 Product 3 .... Product 3000 Etc On sheet 2 I need to reference those cells, and expand it So on sheet 2 I will end up with product1 Product1 product1 product2 product2 product2 product3 product3...

Please help me look for a formula to get the maximum and minimum value based on certain criteria. Thanks. <tbody> Client Campaign Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67%...

Hi, I am trying to compile an array formula to perform following action: Here are input data: Prices in EUR for parts for months <tbody> Jan 2018 Feb 2018 Mar 2018 Apr 2018 PART1 1 2 2 4 PART2 2 3 4 5 PART3 3 4 5 6 </tbody> Structures (bill of material) of finished products <tbody>...

Hi, <tbody> PRODUCTS LOT NO. ERROR TYPE ERROR COUNT TOTAL LOT QT. PRODUCT1 1 ERROR1 2 200 PRODUCT1 1 ERROR2 3 200 PRODUCT1 1 ERROR3 5 200 PRODUCT1 2 ERROR1 2 500 </tbody> I have a similar table to follow production errors. To be able to create a graph later, I don't use a Pivot...

I need to produce the instances of a build sequence by product line. Most products are assembled in the same order but outliers exist. I need to count the number of outliers. Sample: Products buildSequence Product1 MaterialA Product1 MaterialB...

Hi, i'm I'm currently using an INDEX SMALL IF ROWS to return multiple values horizontally for each cell in A1:A100.. I then have to manually TRANSPOSE each row to make it into a verticle list. Is there a way to do this all in one go? I'm at a computer to give an example but it would be...