Forum Discussion
Solved
Increasing Percentage
Hello all' Hope you're all in a good health, in need your help in finding an equation thate gives me % of increase for multipe data point not for to points only as i need to measure the increasement ...
Perhaps you mean trends. To make a calculations, first I'd keep dates as dates, not as texts, applying dd mmm format to them, as in green here
For the linear trend per cent of change could be calculated as
=INDEX(TREND(B6:INDEX(6:6,COUNTA(5:5)),B5:INDEX(5:5,COUNTA(5:5))),COUNTA(5:5)-1)/$B$6-1
In a short i got 300 ticket categories that creates every day as in the example sheet there is a 300 category like this as a daily base data and i just want 1 cell that measure the variance between every to indicate if this case is increasing or decreasing and with how much percentage
Thanks
Thanks
Perhaps you mean trends. To make a calculations, first I'd keep dates as dates, not as texts, applying dd mmm format to them, as in green here
For the linear trend per cent of change could be calculated as
=INDEX(TREND(B6:INDEX(6:6,COUNTA(5:5)),B5:INDEX(5:5,COUNTA(5:5))),COUNTA(5:5)-1)/$B$6-1- That's exactly what i need thank you very much 😁
Mohamed_Gamal , you are welcome