excel - 如何根据特定条件在 excel 中拆分行？

Question

我试图找出一种方法，根据他们已知的潜力将一组给定的客户分成同等大小的区域。以下面的示例为例，我需要将50 个客户分成5 个区域，每个区域10 个客户的潜力总和大约为示例工作表中整个集合的平均潜力25.5。

这在Excel中甚至可能吗？想将它保存在 Excel 中以便能够作为模板共享，但我愿意接受任何其他可能性。

先感谢您

Customer    Potential
Customer 1  1
Customer 2  2
Customer 3  3
Customer 4  4
Customer 5  5
Customer 6  6
Customer 7  7
Customer 8  8
Customer 9  9
Customer 10 10
Customer 11 11
Customer 12 12
Customer 13 13
Customer 14 14
Customer 15 15
Customer 16 16
Customer 17 17
Customer 18 18
Customer 19 19
Customer 20 20
Customer 21 21
Customer 22 22
Customer 23 23
Customer 24 24
Customer 25 25
Customer 26 26
Customer 27 27
Customer 28 28
Customer 29 29
Customer 30 30
Customer 31 31
Customer 32 32
Customer 33 33
Customer 34 34
Customer 35 35
Customer 36 36
Customer 37 37
Customer 38 38
Customer 39 39
Customer 40 40
Customer 41 41
Customer 42 42
Customer 43 43
Customer 44 44
Customer 45 45
Customer 46 46
Customer 47 47
Customer 48 48
Customer 49 49
Customer 50 50

标签： excel