二區數值不一樣 提取 (15094)

I2:J7{=INDEX(B:B,SMALL(IF(VLOOKUP(T(IF({1},$B$2:$B$16)),$E:$F,2,)<>$C$2:$C$16,ROW($2:$16),99),ROW(A1)))&""

K2:K7=IF(I2="","",VLOOKUP(I2,E:F,2,))

G2:G16=REPT("V",VLOOKUP(E2,B:C,2)<>F2)



留言