重複次數與優先次序 顯示 (12376)

H2{=IFERROR(INDEX(B:B,RIGHT(SMALL(IFERROR(MATCH(B$2:B$7,F:F,),9)/1%+ROW($2:$7),INT((ROW(A1)-1)/D$2)+1),2)),"")



留言