请问1－11共11个数字，每5个数字组成一组数，可以有多少种组合？
可以组合462组不重复的，简单得不能在简单了，1到11个数字，5个组合成一组，不重复，如果没猜错是11选5
下面就介绍下实现方法：为了能更好得取值，让数字自动变换，我用了其它符号连接字符，
假如B3=1/2×3-4+5 (也就是你说得5个一组合)
B4
公式向下拉=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&
MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+1&"+"&MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)+2,IF(AND(--LEFT(B3,1)=7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),"",IF(AND(--LEFT(B3,1)<7,--MID(B3,3,1)=8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)+1&"/"&LEFT(B3,1)+2&"×"&LEFT(B3,1)+3&"-"&LEFT(B3,1)+4&"+"&LEFT(B3,1)+5,IF(AND(--MID(B3,3,1)<8,--MID(B3,5,1)=9,--MID(B3,7,2)=10,--RIGHT(B3,2)=11),LEFT(B3,1)&"/"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+1&"×"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+2&"-"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+3&"+"&MID(B3,FIND("/",B3)+1,FIND("×",B3)-FIND("/",B3)-1)+4,IF(AND(--MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)<9,--MID(B3,FIND("-",B3)+1,FIND("+",B3)-FIND("-",B3)-1)=10,--RIGHT(B3,2)=11),LEFT(B3,4)&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+1&"-"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+2&"+"&MID(B3,FIND("×",B3)+1,FIND("-",B3)-FIND("×",B3)-1)+3,))))))
C3公式向右拉在向下拉=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))
