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 of a daily trend for group of data
Thanks
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 of a daily trend for group of data
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
8 Replies
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
