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]"),"一十","十"),"")
留言
張貼留言