ä½è¾
å©åEååFå
E2=COUNTA(B2:D2)
ä¸æè³E5
F2è¾å
¥å¦ä¸æ°ç»å
¬å¼ï¼ç¨Shift+Ctrl+Enterè¾å
¥ï¼ï¼
=MIN(IF(B2:D2<>"",COLUMN(B2:D2),256))-2
G1="å称",H1="ç±»"
G2=A2
G3=IFERROR(IF(COUNTIF(G$2:G2,G2)<INDEX($E$2:$E$5,MATCH(G2,$A$2:$A$5,)),G2,INDEX($A$2:$A$5,MATCH(G2,$A$2:$A$5,)+1)),"")
ä¸æ
H2è¾å
¥å¦ä¸æ°ç»å
¬å¼ï¼ç¨Shift+Ctrl+Enterè¾å
¥ï¼ï¼
=IFERROR(INDEX($A$2:$D$5,MATCH(G2,$A$2:$A$5,),COUNTIF(G$2:G2,G2)+1+INDEX($F$2:$F$5,MATCH(G2,$A$2:$A$5,))),"")
ä¸æ
温馨提示:答案为网友推荐,仅供参考