Excel Math Program With Remainders

Job ID: 32606618

Budget: $30 – $250 USD

Need an excel program with following criteria:
1. You input 1 to 4 Divisors
2. The program will look at all Dividends given in another sheet
3. Outputs lowest to highest remainder from given selection of dividends
4. If more than 1 divisor, it will calculate which dividend outputs lowest remainder with how the divisors were divided into dividend.

Example 1
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 10 (from user)
Remainder = 2, 0, 1, 1, 1.5 (output shows highest to lowest in color change conditional formatting)

Example 2
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 11, 13.5, 10(from user up to 4 variables)
Remainder =
(output remainder shows highest to lowest in color change conditional formatting)
(Output shows all combinations from best combination with lowest remainder to combinationwith highest)

42:
1, 1, 1, rem 7.5
Etc.
50:
1, 1, 2, rem 5.5
1, 2, 1, rem 2
2, 1, 1, rem 4.5
61:
1, 1, 2, rem 6.5
1, 2, 1, rem 3
2, 1, 2, rem 5.5
2, 2, 1, rem 2
3, 1, 1, rem 4.5
1, 3, 0, rem 9.5
2, 3, 0, rem 8.5
3, 2, 0, rem 1
45.5:
1, 1, 2 rem 1
1, 2, 0, rem 7.5
2, 1, 1, rem 0
Etc.
Related categories: Visual Basic Data Processing Excel Mathematics