C2{=IFERROR(LOOKUP(1,0/(LOOKUP(B$1:B1,{0,1,2,3}*1000,{1,2,3,4})=LOOKUP(B2,{0,1,2,3}*1000,{1,2,3,4})),C$1:C1),"")&IF(SUM(N(LOOKUP(B$2:B2,{0,1,2,3}*1000,{1,2,3,4})=LOOKUP(B2,{0,1,2,3}*1000,{1,2,3,4})))=1,"","")&A2
I2=LOOKUP(1,0/(LOOKUP(B$2:B$14,{0,1,2,3}*1000,{1,2,3,4})=ROW(A1)),C$2:C$14)
J2=SUMPRODUCT(ISNUMBER(FIND(A$2:A$14,I2))*B$2:B$14)
留言
張貼留言