选择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)))
