Re: $$Excel-Macros$$ Calculating direction of change across several cells

2010-11-24 Thread 0 1
> 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

Re: $$Excel-Macros$$ Calculating direction of change across several cells

2010-11-17 Thread Paul Schreiner
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