type1

I am looking for some help in one formula to get the desired output...I have data table something like below...which includes Name, Date, Amt, Type and Place... I have only Type1, Type2 and South, North...these will not change. <colgroup><col span="2"><col><col><col></colgroup><tbody> Name...

Hello, I would need your help with an Index, Match array formula which works partially. In range F1:F16 I have the codes in the table below, obtained by combining 4 letters (M,S,Q,D) with nothing or 3 digits (1,2,3). These codes correspond to the types in range G1:G16. In column A I have...

In tab1, I have a table with the end user will complete: <tbody> Type Check 1 Check 2 Check 3 Check 4 Check 5 Check 6 Check 7 Check 8 Check 9 Combined Check Type1 L M L H H Type2 M L M M M </tbody> In tab2, Column B is what I'm attempting to get as an end result. I can't...

Hi, Is it possible to convert rows to columns using Power Query, as in the example below: FROM: <tbody> Code Type 123 a 123 b 123 c 456 d 456 e 789 f 789 g </tbody> TO: <tbody> Code Type1 Type2 Type3 123 a b c 456 d e 789 f g </tbody> Thanks

<tbody> TYPE1 TYPE2 TOTAL1 TOTAL2 PERCENTAGE E BT 50000 50000 I NEED TO CALCULATE 3% OF SUM TOTAL1 &2 IF TYPE 1 IS "E/F/O" AND TYPE2 IS "DT"... IT SHOULD BE 5% IF TYPE1 IS "E" AND TYPE2 IS "BT" E DT 50000 50000 F DT 150000 50000 O DT 250000 50000 </tbody> Please help me to find the...

Hopefully someone can help me. This seems like it should be easy but I just cant figure it out. I have a macro that will insert a chart (XYScatterLinesNoMarkers) and plot the data series. Where I'm getting stuck is that the number and type of data are variable. Example: <tbody> Series Data...