E3=OFFSET(I$2,IFERROR(LOOKUP(1,0/(B3-LEFT(H$3:H$18,6)>=0),ROW($3:$18)),3)+IFERROR(LOOKUP(1,0/(C3-LEFT(I$3:I$6,6)>=0),ROW($3:$6)),3)-5,IFERROR(LOOKUP(1,0/(LEFTB(J$2:N$2,2)-D3<=0),COLUMN(A:E)),1))
數據J2:N2與H3:I18不可變動=OFFSET(D$2,(MATCH(B3-1%%,{0,88,93,98}%)-1)*4+MATCH(C3-1%%,{0,72,82,92}%),MEDIAN(D3,6,10))
數據J2:N2與H3:I18不可變動{=SUM(TRANSPOSE(FREQUENCY(D3,{6,7,8,9}))*OFFSET(J$2:N$2,(LOOKUP(B3,{0,88.001,93.001,98.001}%,{1,2,3,4})-1)*4+LOOKUP(C3,{0,72.001,82.001,92.001}%,{1,2,3,4}),))
留言
張貼留言