可以使用筛选中的“自定义筛选”,把某一特定字段的数据筛选出来,具体操作步骤如下:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/29381f30e924b8994b92610563061d950a7bf665?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、打开excel表格后,点击功能区的数据功能。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46512a90cac8b87d6277ff9d8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选择数据功能区中的【自动筛选】选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a044ad345982b2b7e4b522f93cadcbef76099be0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击“筛选”的倒三角图标,在弹出的窗口选择“数字筛选”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e93901604f960376ec54e736d196b9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选择【自定义筛选】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/267f9e2f07082838c1fdc729b599a9014c08f11f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、将筛选条件设置为包含,把想要筛选的特定字段输入到内容框中后点击确定,如“618”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a2977adcff39425bc315c607ca1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、完成筛选,含有特定字段的数据显示出来,没有该字段的则被隐藏。
注意:自定义筛选除了包含,还有等于、不等于、不包含等方式,可以根据个人实际需要使用,通过自定义筛选,对于数据的统计、分析能够更为快捷。
本回答被网友采纳