Buzz
If you need to filter data for printing based on conditions, but the data ranges with the same conditions are scattered, making it tedious to gather them, this article will guide you on efficiently extracting data in Excel, facilitating easy printing of data with common conditions.
1. Simple Data Filtering
For example, suppose you have a data table where you want to filter students with the same total score:
Simply highlight the data range to be filtered -> go to Data -> Filter:
The arrow appearing on the header row assists in data filtering. For example, to filter students with a total score of 22, select the arrow in the T.Score column -> uncheck Select All -> check the value 22 -> click OK:
You have now filtered students with the same total score of 22.
If you want to filter multiple values, for instance, filter students with a total score from 20.33 to 27.83, simply check the values from 20.33 to 27.83. However, this method may not be accurate for large student lists.
2. Conditional Filtering
2.1 Filtering with 1 data field containing 1 condition
For handling large datasets, it is advisable to utilize this method for data filtering.
For example, to filter students who passed, meaning those with a total score greater than 21, the filtered list is moved to a separate sheet for easy printing.
Step 1: Set the condition with the column header and the specified condition value. Note that the header name must match the header in the table to be filtered:
Step 2: Go to the Data -> Advanced:
Step 3: The Advanced dialog appears with options like this:
- Check the Copy to another location option: to select the filtered content to a new location.
- In the List range: section: Click the arrow to select the data range containing the data to be filtered.
- In the Cirteria range: section: Choose the filtering condition for the data.
- In the Copy to: section: Select the position to paste the filtered data after it has been extracted.
Step 4: Finally, click OK -> the data has been filtered to the new location you selected:
2.2 Filtering Data with Multiple Conditions
When filtering data with multiple conditions, ensure that the conditions are on the same row, and the column header containing the filtering condition must match the column header in the source data table.
For example, to filter students with a total score greater than 21 and math score greater than 8 for enrollment in a selected class, create a condition column as shown:
Similar to filtering data with one condition, in the Cirteria range section, select all the conditions you created:
Successfully filtered data with 2 conditions, making it easy to organize students into the math elective class.
Similarly, if you wish to place students in the literature or language arts elective, select accordingly.
Here is a detailed guide to effortlessly filter data, saving you time in your work.
Wishing you success!
