variation

I have a working sum product =(SUMPRODUCT((MONTH(date)=(MONTH($C$2)))*(YEAR(date)=(YEAR($C$2)))*(MovementType=$I$2)*(Paper=$B6),SQMa)) the problem is (Paper=$b6) b6 could contain more than one product code variation eg 12345 / 32511 / 45722 is there a way to make it look for the all of...

Ok Gang, I have a project with a crazy time crunch and was hoping to have some help on the below. I have a query of data that has a column with my Lookup Value (Variation 1) and a secondary column with an offsetting value that is backwards (Variation 2). If you look at the data in column...

I'm wanting to concatenate some rows dependent upon if they are a different value. So in column C i want to say =IF(D2="Variable",concatenate(c3,c4),c2) So i need the formula to check if parent sku is the same as the child sku, then if it does, then concatenate both of them skus together, and...

Hi Guys, i'm trying to find a pretty long winded formula which hopefully will save me a few days work... I will simplify everything as much as I can then show an example... I have the following fields. <tbody> Type Sku Var1Name Var1Value Var2name Var2Value Var3name Var3Value...

Hi guys. I'm trying to generate a CSV which with a variable product formation and need to auto populate a field.... Table below shows how my layout works, I need to read collumn A and if variation is followed by variable, then collumn C needs to be populated with collumn B. If variation...

Hi guys, I need to do a chart to represent a the variation on 2 variables. It would be good if the variation appears at bars from the minimum to the maximum values for both axes (for both variables). Link to an example...

Good morning, I am trying to setup a function or macro that will help me compare two sets of information, but keep getting stuck. I have two sets of information like below: <colgroup><col><col><col><col></colgroup><tbody> Old Quantity New Quantity A123 50 A123 75 B123 125 B123 50 C123...

Hi Everyone, Probably you’re not going to understand what I’d like, but I try to explain. Please help if you could. I’ve 4 column table, let say source, in worksheet „source”. These tables comes from different companies. Unfortunatelly they have similar products, but mostly those has slightly...