缺少中文值 找出 (12535)

G2:G13{=INDEX(D:D,MIN(IF(COUNTIF(G$1:G1,D$2:D$20)=0,ROW($2:$20),99)))&""

G16:G20{=IFERROR(SUBSTITUTE(TEXT(SMALL(IF(ISNA(MATCH(SUBSTITUTE(TEXT(ROW($1:$19),"[DBNUM1]"),"一十","十"),G$2:G$13,))*(ROW($1:$19)<=MAX(IFERROR(MATCH(G$2:G$13,SUBSTITUTE(TEXT(ROW($1:$19),"[DBNUM1]"),"一十","十"),),))),ROW($1:$19)),ROW(A1)),"[DBNUM1]"),"一十","十"),"")

I2:I6{=IFERROR(SUBSTITUTE(TEXT(SMALL(IF(ISNA(MATCH(SUBSTITUTE(TEXT(ROW($1:$19),"[DBNUM1]"),"一十","十"),D:D,))*(ROW($1:$19)<=MAX(IFERROR(MATCH(G$2:G$13,SUBSTITUTE(TEXT(ROW($1:$19),"[DBNUM1]"),"一十","十"),),))),ROW($1:$19)),ROW(A1)),"[DBNUM1]"),"一十","十"),"")



留言