excel在N个数字当中选择其三个排列而且不重复

来源:百度知道 编辑:UC知道 时间:2024/05/24 23:03:27
excel在N个数字当中选择其三个排列而且不重复
不可以运行啊
你能编个例子发给我吗
weizhengxingfu@qq.com
就是在很多的数字当中选择任意三个数字组合但不可以重复

http://zhidao.baidu.com/question/103737518.html?fr=im2

看我回答的这个问题,基本一样~~

按你的修改为

Function ABC(arr As Range, num As Integer)
R = arr.Rows.Count
For C1 = 1 To R
For C2 = C1 + 1 To R
For C3 = C2 + 1 To R
rr = rr + 1
ABC = arr(C1, 1) & "," & arr(C2, 1) & "," & arr(C3, 1)
If rr = num Then Exit Function
Next
Next
Next
End Function

=======================
已发给你~~

描述详细点。