Nick
New member
- Joined
- Mar 7, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I'd like to automatically divide the amount in a column over # of quarters (a parameter in column O) starting the quarter specified in column B without macro.
Note, the text specifying the quarters in column B matches the column headers in columns C through M.
Screenshot is provided below and the excel file is attached. Currently I have just divided by 4 manually to show as an example.
I'd appreciate any help you can provide. Thanks, Nick.
Note, the text specifying the quarters in column B matches the column headers in columns C through M.
Screenshot is provided below and the excel file is attached. Currently I have just divided by 4 manually to show as an example.
I'd appreciate any help you can provide. Thanks, Nick.