Instructions on how to extract data in Excel

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.

Instructions on how to extract data in Excel Picture 1

1. Simple extracting data

For example, a table of data to extract students with the same score:

Instructions on how to extract data in Excel Picture 2

You only need to highlight the data area to be extracted -> into Data -> Fillter:

Instructions on how to extract data in Excel Picture 3

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:

Instructions on how to extract data in Excel Picture 4

The result you have extracted students with the same score of 22.

Instructions on how to extract data in Excel Picture 5

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.

Instructions on how to extract data in Excel Picture 6

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:

Instructions on how to extract data in Excel Picture 7

Step 2: Go to Data tab -> Advanced:

Instructions on how to extract data in Excel Picture 8

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.

Instructions on how to extract data in Excel Picture 9

Step 4: Finally, click OK -> the data has been extracted to the new location you have selected:

Instructions on how to extract data in Excel Picture 10

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:

Instructions on how to extract data in Excel Picture 11

Similar to filtering data with a condition, with many conditions in Cirteria range, you select all created conditions:

Instructions on how to extract data in Excel Picture 12

As a result, you have extracted data with 2 conditions, easily arranging students into maths selection class:

Instructions on how to extract data in Excel Picture 13

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!