I want a table in a sheet to look at data in another sheet that shows whether a group of students are on target or not for their expected grades. It should count and place the correct amount of students in the corresponding column (see below). It needs to be able to only look at filtered data and if it could also show the names of the pupils that correspond to that number if you hover over that would be amazing!! an example of the table is below!

Please help!!!! thanks Dan#


U G F E D C B A A*
T
B 1
N 1
2c
2b 1 1
2a
3c 1 5 1
3b 1 2 4
3a 1 6 9
4c 6 15 1
4b 11 24 5 2
4a 15 7 1 1
5c 7 16 6 1
5b 3 16 1 1
5a 5 1 2