Prompt says Top 5 scores but only Top 2 scores are displayed.

[James Perry]

I have the names of 10 students in column A and scores in column B.
Each student has 10 subjects. That's 100 rows of student-data + row 1 for the labels.
I put on the Filter. Next i apply the text filter for a single student.
That gives 10 lines of data for a single student.
Then i apply the number filter to view the Top 5 scores for the same student.
But Excel displays only 2 scores although the prompt on the score label says Top 5 items.
I'm using Excel 2013.
Thank you.

 

[Ratan Bhushan]

Please upload the sample file

 

[NARAYANK991]

Hi James ,

That is the way it works. In an AutoFilter , the filters on the columns are all independent.

If you wish to have such a filter , you can use the Advanced Filter where you can set the criteria.

See the file.

Narayan