K2=VLOOKUP(J2,OFFSET(A$2,,SUMPRODUCT((A$2:H$14=J2)*(A$1:H$1=J$1)*COLUMN(A:H))-1,13,2),2,)
另解=VLOOKUP(J2,OFFSET(A:B,,INT(SUMPRODUCT((A$2:H$14=J2)*(A$1:H$1=J$1)*COLUMN(A:H))/2)*2),2,)
另解{=INDIRECT(TEXT(SUM(IF((A$2:G$14=J2)*(A$1:G$1=J$1),ROW($2:$14)/1%+COLUMN(B:H))),"!R0C00"),)
留言
張貼留言