If all you want to do is find records greater than 90% - there is no need to use
Advanced Filter!
Advanced Filter is used when you want to filter by MORE than one criteria!
Using your Spreadsheet as an example:
If you wanted to know the names of students who achieved more than
5% in
Quiz 1 AND more than
12% in the
Practical, then you would use an
Advanced Filter:
- Copy row 2 (the headings) and paste below, or create two blank rows above your table and paste there (you MUST have at least one blank row below the pasted headings!).
- In the blank row below the pasted heading, fill in the criteria for each column required (>5%, for column C), (>12%, for column J)
- Open the Advanced Filter and choose to 'Sort in place'.
- The List range is the full existing list (A4:M10)
- The Criteria range is the pasted header and criteria row (A2:M3)
- Click OK
The list will now only show
4 names - those are the students who scored more than
5% in
Quiz 1 AND >
12% in the
Practical