EXCEL表中200个数据任选3个组合,要求倒序不重复,顺序无要求
请EXCEL和数学高手帮忙~~~高分急求~~我想要达到的目标:我在项目列(A列)填上数据,C列就会自动出现所有无重复的组合得到可以验算组合数的数学公式高手能帮忙解释一下函数的含义吗?ALT+F11 后在VBA中输入的函数:Function 朱科技(zhu As Range, num As Integer)R = zhu.Rows.CountFor A1 = 1 To RFor A2 = A1 + 1 To RFor A3 = A2 + 1 To Rrr = rr + 1朱科技 = zhu(A1, 1) & "," & zhu(A2, 1) & "," & zhu(A3, 1)If rr = num Then Exit FunctionNextNextNextEnd Function在表格中任一空白处输入的公式: =朱科技($A$1:$A$10,ROW(A1))