提取指定年级 且依序相聚 (14212)

G3:I13{=IFERROR(INDEX(C:C,RIGHT(SMALL(IF(1-ISNA(MATCH($C$3:$C$21,$K:$K,)),MATCH($C$3:$C$21,$K:$K,)/1%+ROW($3:$21)),ROW(A1)),2)),"")



留言