I have table including column A is number from $1$ to $10$ based the number of names student and coulmn B is names of students are sara $,$nora $,$hind,laila,hana,maha,wasf $,$hrtk$,$khssr$,$noh

and coulmn C is id of student

I want when filter the names of students from headers of students names and choose hind and noh the table filter it for: hind and noh and the coulmn A would be like :$1,2(1)$for hind and $(2)$for hana if i want add one like noh would be add on coulmn A automatically number $3$

when not filter the names of student or coulmn C it back to $1$ to $10$ on column A number that what i want not when filter names of students on coulmn B like hind and hana would be lkie on coulmn A $3,5$ I don$$t want like this

How to arrange the number based on names when filter the columns can do it on excel