举报
凌乱不堪325
=OFFSET($A$1,,MATCH(MAX(B2:D2*10^5-COLUMN(A:C)),B2:D2*10^5-COLUMN(A:C),))&OFFSET($A$1,,MATCH(LARGE(B2:D2*10^5-COLUMN(A:C),2),B2:D2*10^5-COLUMN(A:C),))&IF(COUNTIF(B2:D2,MIN(B2:D2))=1,"",OFFSET($A$1,,MATCH(MIN(B2:D2*10^5-COLUMN(A:C)),B2:D2*10^5-COLUMN(A:C),)))
数组公式,Ctrl+Shift+回车结束