W5{=OFFSET(A1,SUM((N(OFFSET(A1,ROW(1:10),{0,1,2,3}*5))=W3)*ROW(1:10)),SUM((N(OFFSET(A1,ROW(1:10),{0,1,2,3}*5))=W3)*{0,1,2,3}*5)+MATCH(W4,B1:D1,))
另解=OFFSET(A1,SUMPRODUCT((A2:T11=W3)*(A1:T1=V3)*ROW(1:10)),SUMPRODUCT((A2:T11=W3)*(A1:T1=V3)*COLUMN(A:T))+MATCH(W4,1:1,)-2)
另解=VLOOKUP(W3,OFFSET(A:E,,INT(SUMPRODUCT((A2:T11=W3)*(A1:T1=V3)*COLUMN(A:T))/5)*5),MATCH(W4,1:1,),)
留言
張貼留言