B16=IFERROR(INDEX(OFFSET(INDIRECT("透视表!j"&MATCH($B$3,透视表!$I:$I,)),,,SUM(SMALL(IF(透视表!$I$5:$I$31>=$B$3,ROW($5:$31)),{1,2})*{-1,1}),4),ROW(A1),1),""),数组三键,下同
C16=IFERROR(INDEX(OFFSET(INDIRECT("透视表!j"&MATCH($B$3,透视表!$I:$I,)),,,SUM(SMALL(IF(透视表!$I$5:$I$31>=$B$3,ROW($5:$31)),{1,2})*{-1,1}),4),ROW(A1),2),"")
E16=IFERROR(INDEX(OFFSET(INDIRECT("透视表!j"&MATCH($B$3,透视表!$I:$I,)),,,SUM(SMALL(IF(透视表!$I$5:$I$31>=$B$3,ROW($5:$31)),{1,2})*{-1,1}),4),ROW(A1),3),"")
F16=IFERROR(INDEX(OFFSET(INDIRECT("透视表!j"&MATCH($B$3,透视表!$I:$I,)),,,SUM(SMALL(IF(透视表!$I$5:$I$31>=$B$3,ROW($5:$31)),{1,2})*{-1,1}),4),ROW(A1),4),"") |