合併格 各組由大至小排序 (131617)

G2:H16{=INDEX(C:C,RIGHT(SMALL(MATCH(LOOKUP(ROW(1:15),ROW(1:15)/($F$2:$F$16<>""),$F$2:$F$16),$F:$F,)/1%%-$D$2:$D$16/1%+ROW($2:$16),ROW(A1)),2))



留言