- Picture and text skills
The filtering function in Excel is one of the most commonly used functions in our work. On the basis of ordinary filtering, advanced filtering can also be performed.
Advanced filtering can horizontally filter the relationship where the condition is AND, the vertical filtering condition is the relationship of OR, and the horizontal and vertical mixed filtering condition is the relationship of AND and and or.
Let me show you how to use the advanced filtering function to perform mixed horizontal and vertical filtering.
■Take this form as an example, click Start-Filter-Advanced Filtering, and the list area will be automatically filled.
Enter the corresponding conditions in the condition area, data of origin in Jiangsu and quantity greater than 5,000, or data of origin in Liaoning, quantity greater than 3,000.
Click OK to quickly filter.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-gao-ji-shai-xuan-jin-xing-duo-tiao-jian-shai-xuan.html
评论列表(196条)
测试