D2{=SUM(RIGHT(LARGE(IFERROR(MID(TEXT(MID("@"&PHONETIC(B2:B5),ROW(1:39),COLUMN(A:I)),),2,COLUMN(A:I))*1,)+ROW(1:39)*10^8,ROW(1:39)*9-8),8)*1)
單格只可單個數字D2{=SUM(RIGHT(LARGE(IFERROR(MID(B2:B5,RIGHT(SMALL(FIND(COLUMN(A:J)-1,B2:B5&1/17)+{1;2;3;4}/1%,{1;2;3;4}*10-9),2),COLUMN(A:I))*1,)+{1;2;3;4}*10^8,{1;2;3;4}*9-8),8)*1)
留言
張貼留言