G4=SUMPRODUCT(LEN(B$3:D$5)-LEN(SUBSTITUTE(B$3:D$5,ROW(A1)-1,)))
E8{=MID(SUM(MOD(10-LARGE(G4:G13/1%-ROW(1:10)+1,ROW(1:10)),10)*10^-ROW(1:10))&0,3,10)
E9{=MID(SUM(MOD(10-LARGE(MMULT(COLUMN(A:I)^0,6-LEN(SUBSTITUTE(TEXT(RIGHT(SMALL(B3:D5+{1;2;3}*10^8+{1,2,3}*10^7,ROW(1:9)),6)*1,"0;;"),COLUMN(A:J)-1,)))/1%-COLUMN(A:J)+1,ROW(1:10)),10)*10^-ROW(1:10))&0,3,10)
留言
張貼留言