excel中筛选
详见截图 f2输入 countifs(c:c,">="&left(e2,2),c:c,"(e2,find("-",e2)+1,3)) 公式下拉 g2输入 if(mod(column(),2)=1,index($a:$a,small(if(($c$1:$c$20>=-left($e2,2))*($c$1:$c$20($e2,find("-",$e2)+1,3)),row($1:$20),100),int(column(b1)/2))),index($b:$b,small(if(($c$1:$c$20>=-left... 20210311