縱橫找對應二值 (14409)

D2:F2=OFFSET($A5,$C2,MATCH($C1,$5:$5,)-1+($E5=D5))

D5:H5有順序 1 3 5=OFFSET($C5,$C2,$C1+(D5=$E5))





留言