1到11里面任选5个不重复数字的组合在excel怎么做,每个组合放在5个单 ...答:放在一个单元格就行了,这里用连字符为了更好的让数据取值变换;假如B3=1/2×3-4+5 那么C3公式右拉在下拉=IF(B3="","",IF(--RIGHT(B3,2)=11,"",LEFT(B3,8)&--RIGHT(B3,2)+1))那么B4公式下拉=IF(B3="","",IF(--RIGHT(B3,2)<11,LEFT(B3,5)&"-"&MID(B3,FIND("-",B3...
1到11的组合表,五个数字为一组答:假如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(...