Filter函数间隔提取

 

问题:Filter函数间隔提取

解决:嵌套If或Choose函数

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

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

 

posted @ 2022-03-12 16:44  熬肥妖  阅读(390)  评论(0编辑  收藏  举报