选择A7:E11单元格,输入=RAND() 按Ctrl+Enter组合键结束
选择A9:E13单元格,输入以下公式,按Ctrl+Enter组合键结束
=INDEX($A$1:$E$5,SUMPRODUCT(($A$7:$E$11=LARGE($A$7:$E$11,COLUMN(A1)+(ROW(A1)-1)*5))*ROW($1:$5)),SUMPRODUCT(($A$7:$E$11=LARGE($A$7:$E$11,COLUMN(A1)+(ROW(A1)-1)*5))*COLUMN($A:$E)))