How to filter the top three in excel

How to filter the top three in excel?

Open "Example.xIsx" and ask to filter out the top three data in the field "Sales" column, that is, filter out the top three employees with the best performance.

Select the cell range that needs to be filtered and switch to the "Data" tab. Click the "Filter" button in the "Sort and Filter" options group.

Filter buttons appear on the right side of each field. Click the filter button to the right of "Sales". Select "Number filter > 10 largest values".

The "Auto-Filter Top 10" dialog box pops up, and in the "Display" area, set the filter condition to

"Maximum 3 items". Click the "OK" button.

After performing the above operations, return to the worksheet and you can see that the top three sales data have been filtered out.

For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!

The above is the detailed content of How to filter the top three in excel. For more information, please follow other related articles on the PHP Chinese website!