I have a problem with advanced filter (I know how to solve this question with autofilter)but i want it in advanced filter ..
..the question is( display the records of students whose total is greater than 90 %)



the report is attached

Attached Files

jjjjj.xls (14.0 KB, 18 views)

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