排序 指定欄號與行號起止數字 (14353)

A12:AC20{=IF(OR((SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,)=$AE$2:$AE$9)*(ROW(A1)>=$AF$2:$AF$9)*(ROW(A1)<=$AG$2:$AG$9)),A1,"")

AI{=IFERROR(SMALL(IF($A$12:$AC$20<>"",$A$12:$AC$20),ROW(A1)),"")



留言