A16单元格输入
=INDEX($B2:$B11,MATCH(LARGE($C2:$C11-ROW($C2:$C11)*10^-10,COLUMN()),$C2:$C11-ROW($C2:$C11)*10^-10,0))
Ctrl+Shift+Enter ,数组公式,三键回车。向右复制。OK
A16单元格输入
=INDEX($B2:$B11,MATCH(LARGE($C2:$C11-ROW($C2:$C11)*10^-10,COLUMN()),$C2:$C11-ROW($C2:$C11)*10^-10,0))
Ctrl+Shift+Enter ,数组公式,三键回车。向右复制。OK