步骤方法
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd111eb414aebf12c8fcc3ce2d39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第一步:在Excel里面打开一个单元格,在菜单栏找到数据/筛选/自动筛选。在每一列当中都会有个小三角。用鼠标点击语文下面的小三角,会弹出一个快捷菜单,然后点击自定义,打开自定义。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95ca8e48f438cf177f3e660952fa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第二步:出现自定义自动筛选方式,在语文的下拉中选择大于或等于。在隔壁的方框内填入90。选择或,下面的选择小于,和60。然后确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f24cc1a8a8dce95d143ac4b03bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第三步:确定之后,在单元格内筛选后的结果就显示出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/95eef01f3a292df5dd6acd9bba315c6035a87396?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第四步:然后我们选择好D66、D67、E66、E68,在里面输入语文>=90、数学、>=90.
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7effc40c9a8fbfaaf51f2de66dd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第五步:然后在单元格中随便选个单元格,在菜单栏里选择数据/筛选/高级筛选,打开.出现高级筛选设置,数据如上图.
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fd8d9ec6fbd088d43f8694279f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第六步:我们点击高级筛选里的条件区域.然后用鼠标选中D66至E68再点击红色按钮,返回.
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95ca8fcaf338cf177f3e67095204?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第七步:然后点击复制到右边的红色按钮,然后用鼠标选中需要保存的第一个单元格,选好之后按红色按钮,返回.
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/359b033b5bb5c9eae86b626dd339b6003bf3b3a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第八步:设置好后按确定.这样需要筛选的结果就都出来了.