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
Please submit a small sample file to illustrate how your data is structured.
- 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- 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
