问题:Filter函数间隔提取
解决:嵌套If或Choose函数
=FILTER(IF({1,0},A2:A12,C2:C12),A2:A12="甲")
=FILTER(CHOOSE({1,2},A2:A12,C2:C12),A2:A12="甲")