> you can NEVER return a "2" which represents:
> "If every year since the max experienced a percent increase"
Ah! Oops.
And thank you for the macro. I will try it out.
As for this:
> Second is somewhat of a "logic" issue:
> you really don't need to know what the PERCENT increase/decrease per ye
First of all,
you can NEVER return a "2" which represents:
"If every year since the max experienced a percent increase"
Because: If you find the MAX of the 5 years,
then check it against the following year and the following year
there was an INCREASE, then evidently you didn't find the MAX correc