ChetManley
New Member
- Joined
- Dec 9, 2019
- Messages
- 33
- Office Version
- 2010
- Platform
- Windows
Hi everyone,
I have a table with 12 columns containing monthly balances of our customers:
I need to calculate the variation between consecutive months (Jan to Feb, Feb to March, so on..) and return the highest of these variations (in above example would be Nov to Dec - +900).
Even though this can be easily done, albeit with several steps - i.e. calculate the variation between each month separately by adding extra columns - and then doing a MAX on those cells.
Is there a more elegant solution here that I'm missing?
I'm open to any type of solution (VBA, formula, etc)
Much appreciated,
Chet
I have a table with 12 columns containing monthly balances of our customers:
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
10 | 3.5 | 55 | 1 | 90 | 500 | 123 | 44 | 44.5 | 31.2 | 0 | 900 |
I need to calculate the variation between consecutive months (Jan to Feb, Feb to March, so on..) and return the highest of these variations (in above example would be Nov to Dec - +900).
Even though this can be easily done, albeit with several steps - i.e. calculate the variation between each month separately by adding extra columns - and then doing a MAX on those cells.
Is there a more elegant solution here that I'm missing?
I'm open to any type of solution (VBA, formula, etc)
Much appreciated,
Chet