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
Hyg
I need a % of increasing or decreasing in the sequence of the number in order to get a final % if the case is overall increase or decrease
Thansk
I need a % of increasing or decreasing in the sequence of the number in order to get a final % if the case is overall increase or decrease
Thansk
- Thanks for caring but this got me multiple cells and i want only on cell that got a % of increasing or decreasing, in another way when you represet those data point in a linrar graph and then choose the exponential trend line it will give you a line across the graph which indicates either increase or decrease i want the same result but in a 1 cell / 1 value / 1 percentages
Thanks- 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
ThanksPerhaps 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