Hi All,
Here is my requirement, i.e. here COL A & B will be the key ORAs combination of these two should be unique. Based on this i need to merge (sum) the rows and sum up COL C D E but need to calculate the percentage diff based on the below formula.. Also one more thing i.e. like COL C to COL F (1 set), i have 39 to 45 more sets, which means need to sum up COL G H I and find the percentage diff using formula for COL J and again sum up COL K L M and find pct diff for COL N, etc.......
would you please help me on this please.
COL A COL B COL C COL D COL E COL F
a b c1 d1 dif1 pctdif1
disc1 song1234 3 20 -17 =(COL E)/(COL C)*100
disc2 song78 2 30 -18 =(COL E)/(COL C)*100
disc1 song54 1 10 -9 =(COL E)/(COL C)*100
disc3 song4 4 10 -6 =(COL E)/(COL C)*100
disc4 song0 1 15 -14 =(COL E)/(COL C)*100
disc2 song78 2 16 -14 =(COL E)/(COL C)*100
disc1 song1234 0 19 -19 =(COL E)/(COL C)*100
disc4 song9 1 20 -19 =(COL E)/(COL C)*100
disc1 song1234 0 10 -10 =(COL E)/(COL C)*100
Attached an excel sheet with expected result:
Bookmarks