excel怎么從一串?dāng)?shù)字中提取其中的幾個？

=INDEX(A2:A36RANDBETWEEN(1,35))&"、"&INDEX(A2:A36RANDBETWEEN(1,35))取幾個就鏈接幾次就可以了

用來填寫左邊成績嗎

假設(shè)數(shù)值在A2:F101，共100行5列。

=INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))
隨機得到單元格區(qū)域的一個值
取4個值用如下公式
=INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))&"、"&INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))&"、"&INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))&"、"&INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))