Gaztron3000
New Member
- Joined
- Nov 7, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am trying to forecast customer demand for a product. Using order history, i can estimate a customer's average monthly order, however, some values have decimal points and there is a minimum order quantity required.
I want to write a formula that adds up the total value across a row of data (estimated orders per month) and redistributes the data in groups of 10 (minimum order quantity) across the same number of cells.
example: see attached image.
Is it possible to set a different redistribution value for different customers based on known historical order quantities?
Thanks for any help you can give.
I want to write a formula that adds up the total value across a row of data (estimated orders per month) and redistributes the data in groups of 10 (minimum order quantity) across the same number of cells.
example: see attached image.
Is it possible to set a different redistribution value for different customers based on known historical order quantities?
Thanks for any help you can give.