(先)F4{=INDEX(C:C,SMALL(IF(ISERR(FIND("客戶",C$3:C$29))*ISNA(MATCH(C$3:C$29,J:J,)),ROW($3:$29),99),ROW(A1)))&""
E4{=IFERROR(MID(INDEX(C:C,VLOOKUP(SMALL(IF(C$4:C19=F4,ROW($3:18)),COUNTIF(F$4:F4,F4)),IF(1-ISERR(FIND("客戶",C$3:C18)),ROW($3:18)),1,)),5,9),"")
G4=IFERROR(INDEX(C:C,MATCH(1=1,SMALL(IF(C$4:C19=F4,ROW($4:19)),COUNTIF(F$4:F4,F4))<IF(1-ISNA(MATCH(C$3:C19,J:J,)),ROW($3:19),),)+2),"")
留言
張貼留言