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) |