Buzz
Excel Data Filtering Method
1. Quick Data Filtering in Excel
When you select Filter, filter controls will automatically be added to the column headers in the table as indicated below.
To filter quickly, follow these steps:
Step 1: You click on the triangle icon in the column header to filter data.
Step 2: A dialog appears -> you uncheck Select All in the checkbox. Next, you want to filter data by any item in the column, then you tick the checkbox before that data -> Then click OK.
As a result, you will filter the data you want, and the column header with filtered data will display a filter icon.
To remove the filter -> you click on the filter icon above the column header and select -> Clear Filter From... the image below is Clear Filter From 'Class'.
2. Filtering by Specific Text or Number
Step 1: You select the triangle icon in the cell where you want to filter data.
Step 2: If the data column contains text to be filtered, you select Text Filters. If the data column contains numbers to be filtered, you select Number Filters -> Then click Custom Filter to continue.
Step 3: In the Custom AutoFilter dialog box -> you enter the filter conditions. If there are 2 filter conditions -> then you enter both conditions in the data cells. Then select the relationship between the 2 conditions as And or Or as appropriate for the filter conditions. Finally, click OK.
Example: You need to filter data with the condition Exam Score greater than or equal to 5 to find students who passed the exam.
And here is the result after you filter with conditions:
3. Filtering by Color in Excel
If the data in the table is marked with different colors -> then you can filter data by colors following these steps:
Step 1: Select the filter icon in the column header cell with color formatting.
Step 2: Then select Filter by Color -> then choose the color you want to filter.
The result after you filter by color will be as shown in the image below:
4. Search Filtering in Excel
Starting with Excel 2010, you will notice a filter interface containing a search box. This box helps you search through large data strings very easily, quickly finding data containing specific characters, numbers, or dates...
For example, if you want to view date data -> you click on the filter arrow icon -> in the search box, you enter the content you want to search for -> immediately Excel will display information matching the search condition you just entered.
Here are some effective and useful ways to filter data in Excel collected and compiled by Mytour. With these filtering methods in Excel, you should tailor them to specific situations when working in Excel to use data filtering effectively.
In addition, you can also refer to another small trick when combining data between different Sheets by entering value cells or data array references into calculation formulas instead of just entering value cells or simple data arrays. That is filtering data between Sheets in Excel - readers can refer to the details of these filters in the article shared by Mytour. Wish you success!
