Current location - Training Enrollment Network - Mathematics courses - How to use the advanced screening in excel to screen out people whose English or math scores are greater than 90?
How to use the advanced screening in excel to screen out people whose English or math scores are greater than 90?
1, open an excel file:

2. Enter the students' grades. A set of data is simulated here. 1 * * Yes 1 1 person:

3, input conditions, mathematics is greater than 90, English is greater than 90, pay attention to the staggered columns represent two different conditions, greater than the symbol using English input method:

4, click on the data in the toolbar above:

5, click on the filter fat senior:

6. Select the data just entered in the list area:

7. Conditional area selection The conditional area you just entered is greater than 90:

8. As a result of advanced screening, 8 people scored above 90 in math or English.