å ¬å¼ï¼{=INDEX(C1:N1,MATCH(1,IF(C2:N2=MAX(C2:N2),1,0),0))}ï¼å ¶ä¸ä¸¤ç«¯ç{}éè¦éè¿æctrl+shift+å车é®çæ
ç»æå¦å¾ï¼
å ¬å¼éä¹ï¼
1ãIF(C2:N2=MAX(C2:N2),1,0)çç»ææ¯{0,0,0,0,1,0,0,0,0,0,0,0}
2ãMATCH(1,IF(C2:N2=MAX(C2:N2),1,0),0)=MATCH(1ï¼{0,0,0,0,1,0,0,0,0,0,0,0}ï¼0ï¼çç»ææ¯5ï¼å³ç¬¬5个æ°ä¸º1ï¼ç²¾ç¡®å¹é
3ãINDEX(C1:N1,MATCH(1,IF(C2:N2=MAX(C2:N2),1,0),0))}=INDEX(C1:N1ï¼5ï¼ï¼ç´¢å¼C1:N1åå æ ¼ä¸ç¬¬äºä¸ªå³G1åå æ ¼å 容âåå5â
注ï¼ååå¾å¤æ¶ï¼æå¨æ»è®¡ä¹åå°±å¯ä»¥äº