excel 把这18个数据均匀分成6个小组,让每组的平均值比较接近, 同时显示...答:Private Sub Worksheet_Activate()Dim i, j, k As Integer Let i = 1 Let j = 18 Let k = 12 While i < 7 Let Cells(i, "D") = (Cells(i, "C") + Cells(k, "C") + Cells(j, "c")/3 Let Cells(i, "e") = i Let Cells(i, "f") = k Let Cells(i, "g") ...