Calculating % of upward or downward trend over time.

Hi,

Not sure if this is what you're wanting but the function to produce the trendline log exponent to match your chart trendlines is

Formula:

Please Login or Register  to view this content.

I am not understanding what you are trying to do. If the numbers in column G are the results you expect to obtain, I cannot see how you are obtaining those numbers. I find that these kind of problems are often more algebra than programming. Usually, it seems that the programming task of calculating percent change, and then ranking/comparing those changes is straightforward, once one understands how they would like to calculate percent change. In your case, I don't understand how you want to calculate percent change.

If it helps, I will refer you to a couple of secondary school algebra tutorials: https://www.purplemath.com/modules/percntof3.htm
http://www.algebralab.org/Word/Word....PercentsII.xml
As these tutorials show, percent change is usually expressed as some kind of "how much change" divided by "the starting value" or (final-initial)/initial=%change. I cannot tell what you intend to use as initial and final values for each row.