J2è¾å ¥
=IFERROR(INDEX($B$1:$I$1,MATCH(1,B2:I2,)),"")
ä¸æ
追é®å¦æ1è¿ä¸ªæ°åæ¯ä¸ä¸ªéæºæ°åï¼é£ä¹ä½ çå
¬å¼è¾å
¥å°±ä¸æç«ï¼è¦æä¹åå¢ï¼
æçä½ ä¹åçåçéæ个=INDEX(A2:G2,MIN(IF(A2:G2"",COLUMN(A:G),1000)))çå
¬å¼ï¼æå°è¯çä¿®æ¹=INDEX(B1:G1,MIN(IF(B2:G2"",COLUMN(B:G),1000)))ï¼ä½å¥½åè¿åå¼æäºé®é¢
J2è¾å ¥
=IFERROR(INDEX($A$1:$I$1,MIN(IF(B2:I2<>"",COLUMN($B:$I),100))),"")
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æ