excel怎么从一串数字中提取其中的几个？

一串是什么概念？是从一个单元格中提取吗？如果是，如下图所示，从A1单元格中取4个随机数，C1单元格输入公式=LOOKUP(9^9,--MID("、"&A1&"、",FIND("@",SUBSTITUTE("、"&A1&"、","、","@",RANDBETWEEN(1,LEN(A1)-LEN(SUBSTITUTE(A1,"、",))+1)))+1,ROW($1:$9)))&"、"&LOOKUP(9^9,--MID("、"&A1&"、",FIND("@",SUBSTITUTE("、"&A1&"、","、","@",RANDBETWEEN(1,LEN(A1)-LEN(SUBSTITUTE(A1,"、",))+1)))+1,ROW($1:$9)))&"、"&LOOKUP(9^9,--MID("、"&A1&"、",FIND("@",SUBSTITUTE("、"&A1&"、","、","@",RANDBETWEEN(1,LEN(A1)-LEN(SUBSTITUTE(A1,"、",))+1)))+1,ROW($1:$9)))&"、"&LOOKUP(9^9,--MID("、"&A1&"、",FIND("@",SUBSTITUTE("、"&A1&"、","、","@",RANDBETWEEN(1,LEN(A1)-LEN(SUBSTITUTE(A1,"、",))+1)))+1,ROW($1:$9)))

下拉公式。

示例

假设数值在A2:F101，共100行5列。

=INDEX($A$2:$F$101,RANDBETWEEN(1,100),RANDBETWEEN(1,5))
随机得到单元格区域的一个值
取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))

=INDEX(A2:A36RANDBETWEEN(1,35))&"、"&INDEX(A2:A36RANDBETWEEN(1,35))取几个就链接几次就可以了

用来填写左边成绩吗