A10:B18{=TEXT(OFFSET(A$2,SMALL(IF(LEN($C$3:$C$4)-LEN(SUBSTITUTE($C$3:$C$4,",",))+1>=COLUMN($A:$I),{1;2},99),ROW(A1)),),"YYY/M/D;;;@")
C10:C18=IF(B10="","",INDEX(TRIM(MID(SUBSTITUTE(VLOOKUP(B10,B:C,2,),",",REPT(" ",199)),ROW($1:$9)*199-198,199)),COUNTIF(B$10:B10,B10)))
留言
張貼留言