求助高手们! Excel是否能以offset及lookup做出图中效果答:B2公式:=MAX(OFFSET(Sheet1!$A$1,1,SUMPRODUCT((Sheet1!$A$1:$E$1=$A2)*COLUMN($A$1:$E$1))-1,5,2))或 =MAX(OFFSET(Sheet1!$A$1,1,MATCH(A2,Sheet1!$1:$1,)-1,5,2))C2公式:=MIN(OFFSET(Sheet1!$A$1,1,SUMPRODUCT((Sheet1!$A$1:$E$1=$A2)*COLUMN($A$1:$...