字母結合 扣除該數字的字母 (13558)

G2:G11=SUBSTITUTE(D$2&D$3&D$4&D$5&D$6&D$7&D$8&D$9&D$10&D$11,VLOOKUP(F2,C:D,2,),)

H2:R11=SUBSTITUTE(OFFSET($D$1,COLUMN(A1),)&I2,VLOOKUP($F2,$C:$D,2,),)



留言