How to make formula for my student mark.

https://www.dropbox.com/s/ppy50c67lvf7flx/sample.xlsx?dl=0

please me solve problem. sample file reference. sorry bad language.

1. want's filter data student, more 'a' in exam , put names in coloumn below (sample file).

-for example: names student straight 'a' in exam.

so want's excel filtered automatically.

hi,

please use below formula in cell a14 (*for 8 a)

=iferror(small(if($m$2:$m$8=8,$a$2:$a$8),rows($d$14:d14)),"")

press shift +ctrl+enter after entering formula , drag down

in cell b14

=iferror(vlookup(a14,$a$2:$b$8,2,false),"")

in cell c14

=iferror(vlookup(a14,$a$2:$c$8,3,false),"")

in cell a22 (*for 7 a)

=iferror(small(if($m$2:$m$8=7,$a$2:$a$8),rows($d$14:d14)),"")

press shift +ctrl+enter after entering formula and drag down

cell b22

=iferror(vlookup(a22,$a$2:$b$8,2,false),"")

cell c22

=iferror(vlookup(a22,$a$2:$c$8,3,false),"")

if reply helpful, please mark answer

Office / Excel / Windows 10 / Office 2016

Cororate