排序 依月份數據 (11218)


B12:C16{=OFFSET($B$1,RIGHT(LARGE(OFFSET($A$4,,MATCH($B$10,$3:$3,)-1,5)/1%+ROW($3:$7),ROW(A1))),(MATCH($B$10,$3:$3,)-2)*(B$3=$C$3))


另解(=OFFSET($B$1,MOD(LARGE(OFFSET($B$4:$B$8,,LEFTB($B$10,2))/1%+ROW($3:$7),ROW(A1)),100),LEFTB($B$10,2)*(COLUMN(A1)>1))


留言