To learn more about the basic operation of ex cel, please click ▼▼▼? How to easily calculate percentage in exc el? Exc el, how to make employee attendance sheets efficiently? Methods and steps of using exce l software to do ip ad What is the complete solution? How to convert the table in the figure into Ex cel How to filter courses greater than, less than and equal to in excel 1 Automatic filtering.
Objective: To improve Chinese performance? More than 90 points? Students and Chinese scores? Less than 60 points? Student's.
Excel filter Step 1: Select any cell in the data table and execute it? Data? Screening? Automatic screening? Command, at this time, a drop-down button will appear on the right side of each column title (see figure 1).
Excel filtering Step 2: Click? China? The drop-down button on the right, in the shortcut menu that pops up later (see figure 1), select? Custom? Option, open? Custom automatic filtering method? Dialog box (as shown in Figure 2).
Step 3 of Excel Filtering: Click the drop-down button on the right side of the upper left box, and in the dialog box that appears, select? Greater than or equal to? Option, and then enter a value in the box in the upper right corner. 90? ; Selected? Or? Option, and then click the drop-down button on the right side of the lower left box. In the shortcut menu that appears, select? Less than? Option, and then enter a value in the box in the lower right corner. 60? (See Figure 2).
Step 4 of excel filtering: After setting, click? Are you sure? Button, the qualified data will be filtered out immediately (the filtering result is shown in Figure 3).
Tip: Based on the above screening results, what? Math? Column to continue the filtering operation and set the filtering condition to? Greater than or equal to 90? , can I play it? China? And then what? Math? All the grades? Greater than or equal to 90? The students who scored were screened out.
Second, advanced screening.
Purpose: Will it? China? Or? Math? Grades? Greater than or equal to 90? The students who scored were screened out.
Excel filtering step 1: execute first? Data? Screening? Automatic screening? Order, revocation? Automatic screening? Function. What if it doesn't continue? Automatic screening? Operation, this step can be omitted.
Step 2 of Excel filtering: Select cells D66, D67, E66 and E68 respectively, and input contents: Chinese, > =90, Mathematics, > =90 (as shown in Figure 4).
Excel filtering Step 3: Select any cell in the report and execute it? Data? Screening? Advanced screening? Command, open? Advanced screening? Dialog box (as shown in Figure 5).
Excel filtering Step 4: Select? Copy the filter results to another location? Options.
Tip: You don't have to select this option, but in order to keep the original data, it is recommended to copy and save the filtering results to another location.
Excel filtering Step 5: Click? Conditional areas? The red button on the right. At this point, the dialog box becomes a floating status bar (as shown in Figure 6). Select the D66 to E68 conditional area with the mouse, and then press the red button on the right side of the floating status bar to return? Advanced screening? Dialog box.
Excel filtering Step 6: Click? Copy to? The red button on the right. At this point, the dialog box becomes a floating status bar (as shown in Figure 7). Use the mouse to select the 1 th cell (such as A69) where the filtering result is saved, and then press the red button on the right side of the floating status bar to return? Advanced screening? Dialog box.
Tip:? Data area? The system usually adds it automatically according to the default area. If you need to change, just follow the above operation.
Excel filtering Step 7: After all the settings are completed, click? Are you sure? Button, the qualified data will be filtered out.
Tip: If you put? Conditional areas? Change to the style shown in Figure 8 (that is, the condition values are in the same line), and then perform the above filtering system operation, then only? China? And then what? Math? All the grades? Greater than or equal to 90? Dozens of students were screened out.
& gt& gt& gt More exciting next page? How to filter out values greater than a certain value in excel?