在0-9十个数字任选5个数字，随机组成一个三位数，能在excel用公式做出来么？有图示范教我最好！谢谢！ 如何在EXCEL中输入9个指定数字，然后用公式做出3个为一组...
excel\u4e2d\uff0c0-9\u5341\u4e2a\u6570\u968f\u673a\u7ec4\u54085\u4e2a\u6570\u5f62\u6210\u4e00\u7ec4\u6570\uff0c\u600e\u4e48\u5b8c\u6210\u5148\u770b\u7ed3\u679c
\u6b65\u9aa4\uff1a
1\u3001\u5728D2\u952e\u5165\u516c\u5f0f
=RAND()
\u516c\u5f0f\u4e0b\u62c9\u81f3D11\uff0c\u4ea7\u751f10\u4e2a\u968f\u673a\u6570\u5217
2\u3001\u5728E2\u952e\u5165\u516c\u5f0f
=RANK(D2,D$2:D$11,1)-1
\u516c\u5f0f\u4e0b\u62c9\u81f3E11\uff0c\u4ea7\u751f0-9\u968f\u673a\u6570\u5217\uff0c\u4f7f\u7528RANK()\u51fd\u6570\u662f\u5173\u952e\uff0c\u4fdd\u8bc1\u5f97\u5230\u7684\u6570\u5217\u6bcf\u4e2a\u4e0d\u91cd\u590d
3\u3001\u5728F2\u952e\u5165\u516c\u5f0f
=IF(E2=0,E11,E2)
\u53d6\u4e07\u4f4d\u6570\u5b57\uff0c\u4e3a\u4e86\u4fdd\u8bc1\u4e07\u4f4d\u4e0d\u4e3a0\uff0c\u52a0\u4e86\u5224\u65ad\uff0c\u82e5\u4e3a0\u5219\u53d6E11
4\u3001\u5728F2\u952e\u5165\u516c\u5f0f
=E3
\u516c\u5f0f\u4e0b\u62c9\u81f3F6\uff0c\u53d6\u53e6\u59164\u4e2a\u6570
5\u3001\u5728B2\u952e\u5165\u516c\u5f0f
=SUMPRODUCT(F2:F6,G2:G6)
\u5f97\u5230\u7ed3\u679c
\u5728A\u5217\u968f\u4fbf\u6539\u4e2a\u6570\uff0c\u5c31\u80fd\u5f97\u5230\u4e0d\u540c\u6570
9\u4e2a\u6570\u5b57\u653e\u5728A1:A9\uff0c\u5171\u6709234\u4e2a\u4e0d\u540c\u7684\u7ec4\u5408\uff0c
\u7528VBA\u53ef\u6c42\u51fa\u5168\u90e8\u4e0d\u91cd\u590d\u7684\u5404\u53ef\u80fd\u7ed3\u679c\uff0c\u653e\u5728B\u5728B1\u5f00\u59cb\uff1a
Sub \u5b8f1()l = 1For i = 1 To 7For j = 2 To 8For k = 3 To 9If Not (i = j Or i = k Or j = k) ThenCells(l, 2) = Cells(i, 1) & "," & Cells(j, 1) & "," & Cells(k, 1)l = l + 1End IfNextNextNextEnd Sub\u518d\u7528\u516c\u5f0f\u9009\u51fa\u7ed3\u679c\uff1a=OFFSET(A1,RANDBETWEEN(0,234),1)
Sub try()
Dim i1 As Integer, i2 As Integer, i3 As Integer, k As Integer
k = 2
For i1 = 1 To 5
For i2 = 1 To 5
For i3 = 1 To 5
Range("A" & k).Value = Cells(1, i1) & Cells(1, i2) & Cells(1, i3)
k = k + 1
Next i3
Next i2
Next i1
End Sub
绛旓細鑰冭檻鏁板瓧鍙噸澶嶏紝鏈98缁 {{0,0,2,9,9},{0,0,3,8,9},{0,0,4,7,9},{0,0,4,8,8},{0,0,5,6,9},{0,0,5,7,8},{0,0,6,6,8},{0,0,6,7,7},{0,1,1,9,9},{0,1,2,8,9},{0,1,3,7,9},{0,1,3,8,8},{0,1,4,6,9},{0,1,4,7,8},{0,1,...
绛旓細0-9鍗佷釜鏁涓紝浠婚変簲涓暟鐩稿姞鍜岀瓑浜10鐨勭粍鍚堝彧鏈変竴绉嶏紝鏄4+3+2+1+0=10锛屽畠浠浜斾釜鏁板瓧鍑虹幇鐨勫悓鏍峰銆
绛旓細27216绉 0--9鍏鍗佷釜鏁浠庝腑閫夊彇浜斾釜鏁板瓧锛缁勬垚涓涓簲浣嶆暟瀛楋紝娌℃湁閲嶅A(10,5)-A(9,4)=9x9x8x7x6=27216 鏈涢噰绾筹紒锛
绛旓細灏嗘浜浣嶆暟璁句负98XYZ 琚2銆3銆7銆11鏁撮櫎鍗宠兘琚2*3*7*11=462鏁撮櫎 98000 梅 462 = 212 鈥︹︿綑56 鍒橷YZ 琚462闄ら』浣462-56 = 406 XYZ = 462K + 406锛屽綋K = 0鏃讹紝XYZ = 406 褰揔 = 1鏃讹紝XYZ = 868 褰揔 > 1鏃讹紝XYZ瓒呰繃3浣嶆暟銆傚垯浠呮湁XYZ = 406 杩欎釜浜斾綅鏁板氨鏄 98406 ...
绛旓細8,3)/C(10,5)=2/9.鐚滀笁涓暟瀛椼10涓暟瀛涓殢鏈5涓暟瀛鐨勯夋硶鏈塁(10,5)锛屽惈璇ヤ笁涓暟瀛楃殑閫夋硶鏈塁(7,2), 鐚滀腑杩欎笁涓暟瀛楃殑姒傜巼鏄疌(7,2)/C(10,5)=1/12.鐚滃洓涓暟瀛椼傛鐜囨槸C(6,1)/C(10,5)=1/42.鐚浜斾釜鏁板瓧銆傚惈璇5涓暟瀛楃殑閫夋硶鍙湁1绉嶏紝姒傜巼鏄1/C(10,5)=1/252.
绛旓細鎴戝垰鍒氬湪甯傚ゥ鏍″浜嗘帓鍒楃粍鍚堬紝鍙兘涓嶈兘鍑嗙‘鐨勫府鍒版偍銆備絾鏄LZ棰嗕簡杩欎唤蹇冦傦紙濡傛湁涓嶅悓绛旀璇峰憡璇夋垜 QQ 569334480.锛変竾鍒嗘劅璋傝繖閬撻鍏跺疄鏄粠0锛1锛2锛3锛4锛5锛6锛7锛8锛9杩10涓暟瀛涓彇5涓鈥斺旇繖鏄粍鍚堛 杩5涓湪杩涜鎺掑垪銆傜涓姝ュ簲姹傝兘鍙栧灏戜釜杩欐牱鐨勭粍锛烠 10 5=P 10 5/P 5 5...
绛旓細鍏10x9x8x7x6绉 鏈5涓鍦版柟闇瑕侀夊崱鐗 绗竴涓湴鏂规湁鍗佷釜閫夋嫨 绗簩涓 鍥犱负鐢ㄦ帀浜嗕竴涓繕鍓涔涓 浠ユ绫绘帹鏈鍚庡埄鐢ㄤ箻娉曞師鍒欐妸浠栦滑涔樺湪涓璧 灏辨槸绛旀
绛旓細鍒嗘:鍏堥夌涓浣嶆暟鏈10绉 鍒欑浜屼綅鏈9绉 绗笁浣嶆湁8绉嶁︹﹀嵆N=10*9*8*7*6=30240
绛旓細濡傛灉鍙互閲嶅锛屾湁10鐨5娆℃柟寰100000锛堝崄涓囷級鍙互杩欐牱鑰冭檻锛氱涓涓湁10绉嶉夋嫨锛岀浜屼釜鍙互閲嶅涔熸湁10绉嶉夋嫨銆傘傘
绛旓細10閫5鐨勭粍鍚锛屾暟瀛涓嶉噸澶嶆湁c(10,5)=10脳9脳8脳7脳6锛5!= 252 缁勶紝鏁板瓧鍙噸澶嶅垯鏈10^5= 100000 缁勩
