Filter函数间隔提取


问题:Filter函数间隔提取

解决:嵌套If或Choose函数

=FILTER(IF({1,0},A2:A12,C2:C12),A2:A12="甲")

=FILTER(CHOOSE({1,2},A2:A12,C2:C12),A2:A12="甲")

相关