You want to extract data according to the conditions for printing, but the data areas with the same conditions are far apart, you have to gather them together before you can print. In this article, you can extract data in Excel, which helps you to print conditional data easily.
1. Simple extracting data
For example, a table of data to extract students with the same score:
You only need to highlight the data area to be extracted -> into Data -> Fillter:
An arrow appears in the header row to help you extract the data. For example, if you want to extract students who have a total score of 22. Select the arrow in the Points column -> check the Select All check box -> select the 22 value -> click OK:
The result you have extracted students with the same score of 22.
If you want to extract multiple values, for example, extract students with a total score of 20.33 to 27.83, you just need to select the prices from 20.33 to 27.83. However, this method will not be accurate if the list of students is large.
2. Conditional extracting
2.1 Extract filter with 1 data field containing 1 condition
For large amounts of data you should use this method to extract data.
For example, if you want to extract students who pass the exam with an overall score greater than 21, the filter list is set to another wallet to facilitate the printing process.
Step 1: Make conditions with the column headings and condition values, note here the title name must match the title in the table to extract data:
Step 2: Go to Data tab -> Advanced:
Step 3: Advanced dialog box appears as follows:
- Tick to Copy to another location : to select the extracted content to a new location.
- List List range: Click the arrow to select the data area containing the data to extract.
- Section Cirteria range: Select conditions for extracting data
- Item Copy to: Select the location to paste the content of the data after it has been extracted.
Step 4: Finally, click OK -> the data has been extracted to the new location you have selected:
2.2 Extract data with many conditions
For filtering data that contains many conditions, you need to pay attention, the conditions on the same row and the column header name containing the extraction condition must match the column header name in the source data table.
For example, need to extract students with a total score greater than 21 and a math score greater than 8 to classify in the class you choose to create conditional columns as shown:
Similar to filtering data with a condition, with many conditions in Cirteria range, you select all created conditions:
As a result, you have extracted data with 2 conditions, easily arranging students into maths selection class:
Similarly, if you want to put students in a class to choose literature, choose him.
Above is a detailed guide to help you extract data simply and easily from which to save working time.
Good luck!