I have a list of 49 4 digit numbers (Col B below).
I would like to sort them in to 7 (or any other number) of Columns where the sum of each small list are as close to each other as possible as seen in Cols C to I.
the sorting below was done on a an online site but I would like to have it on my desktop for when I'm offline, as I am sometimes.
Many thanks
I would like to sort them in to 7 (or any other number) of Columns where the sum of each small list are as close to each other as possible as seen in Cols C to I.
the sorting below was done on a an online site but I would like to have it on my desktop for when I'm offline, as I am sometimes.
Many thanks
| packs (1).csv | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | |||
| 1 | 3166 | 3048 | 3105 | 3061 | 3092 | 3130 | 3108 | 3166 | ||
| 2 | 3130 | 3019 | 3096 | 3052 | 3078 | 2937 | 3081 | 3070 | ||
| 3 | 3108 | 2797 | 2791 | 3018 | 2902 | 2809 | 2750 | 2781 | ||
| 4 | 3105 | 2789 | 2668 | 2681 | 2694 | 2743 | 2748 | 2743 | ||
| 5 | 3096 | 2733 | 2656 | 2590 | 2634 | 2706 | 2649 | 2643 | ||
| 6 | 3092 | 2598 | 2649 | 2581 | 2586 | 2627 | 2613 | 2582 | ||
| 7 | 3081 | 2574 | 2594 | 2575 | 2573 | 2604 | 2606 | 2573 | ||
| 8 | 3078 | |||||||||
| 9 | 3070 | 19558 | 19559 | 19558 | 19559 | 19556 | 19555 | 19558 | ||
| 10 | 3061 | |||||||||
| 11 | 3052 | |||||||||
| 12 | 3048 | |||||||||
| 13 | 3019 | |||||||||
| 14 | 3018 | |||||||||
| 15 | 2937 | |||||||||
| 16 | 2902 | |||||||||
| 17 | 2809 | |||||||||
| 18 | 2797 | |||||||||
| 19 | 2791 | |||||||||
| 20 | 2789 | |||||||||
| 21 | 2781 | |||||||||
| 22 | 2750 | |||||||||
| 23 | 2748 | |||||||||
| 24 | 2743 | |||||||||
| 25 | 2743 | |||||||||
| 26 | 2733 | |||||||||
| 27 | 2706 | |||||||||
| 28 | 2694 | |||||||||
| 29 | 2681 | |||||||||
| 30 | 2668 | |||||||||
| 31 | 2656 | |||||||||
| 32 | 2649 | |||||||||
| 33 | 2649 | |||||||||
| 34 | 2643 | |||||||||
| 35 | 2634 | |||||||||
| 36 | 2627 | |||||||||
| 37 | 2613 | |||||||||
| 38 | 2606 | |||||||||
| 39 | 2604 | |||||||||
| 40 | 2598 | |||||||||
| 41 | 2594 | |||||||||
| 42 | 2590 | |||||||||
| 43 | 2586 | |||||||||
| 44 | 2582 | |||||||||
| 45 | 2581 | |||||||||
| 46 | 2575 | |||||||||
| 47 | 2574 | |||||||||
| 48 | 2573 | |||||||||
| 49 | 2573 | |||||||||
packs (1) | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C9:I9 | C9 | =SUM(C1:C8) |
