csimarketing
New Member
- Joined
- Jun 18, 2019
- Messages
- 15
- Office Version
- 2019
- Platform
- MacOS
Hello,
I am trying to get a rolling/dynamic formula that calculates the MIN and MAX of the most recent 12 months, but all of the threads I can find are not specific enough. Any help would be greatly appreciated!
MIN formula should return: 2
MAX formula should return: 84
Thank you!
I am trying to get a rolling/dynamic formula that calculates the MIN and MAX of the most recent 12 months, but all of the threads I can find are not specific enough. Any help would be greatly appreciated!
MIN formula should return: 2
MAX formula should return: 84
Month | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | MIN Last 12 Months | MAX Last 12 Months |
QTY | 20 | 4 | 54 | 16 | 77 | 84 | 2 | 46 | 65 | 43 | 12 | 34 | 54 | 78 | 13 |
Thank you!