H3:K30{=INDEX($A:$A,SMALL(IFERROR(IF((RANK(OFFSET($A$2:$A$59,,MATCH($H$1,$1:$1,)-1),OFFSET($A$2:$A$59,,MATCH($H$1,$1:$1,)-1))/(COUNTA($A:$A)-1)>SUM((0&MID($G$2:G$2,3,3))*1))*(RANK(OFFSET($A$2:$A$59,,MATCH($H$1,$1:$1,)-1),OFFSET($A$2:$A$59,,MATCH($H$1,$1:$1,)-1))/(COUNTA($A:$A)-1)<=SUM((0&MID($H$2:H$2,3,3))*1)),ROW($2:$59),4^8),4^8),ROW(A1)))&""
E2=RANK(OFFSET(A2,,MATCH(H$1,$1:$1,)-1),OFFSET(A$2:A$59,,MATCH(H$1,$1:$1,)-1))
留言
張貼留言