G
Guest
Hello! Please help with data below - sum col B based on top 2 of col C and
group by Col A. T1=70+100=170, T2 = 400+300=700, T3=150+110=260
Thank you so much for helping.
Col A Col B Col C
T1 100 20%
T3 150 15%
T2 400 30%
T1 400 10%
T1 70 50%
T2 120 18%
T1 150 15%
T2 300 30%
T3 110 10%
group by Col A. T1=70+100=170, T2 = 400+300=700, T3=150+110=260
Thank you so much for helping.
Col A Col B Col C
T1 100 20%
T3 150 15%
T2 400 30%
T1 400 10%
T1 70 50%
T2 120 18%
T1 150 15%
T2 300 30%
T3 110 10%