Question: I have table including column A is number from 1 to 1 0 based the number of names student and coulmn B is names of
I have table including column A is number from to based the number of names student and coulmn B is names of students are sara nora hind,laila,hana,maha,wasf hrtkkhssrnoh
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 :for hind and for hana if i want add one like noh would be add on coulmn A automatically number
when not filter the names of student or coulmn C it back to to 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 I dont want like this
How to arrange the number based on names when filter the columns can do it on excel note : I dont have filter function on my excel
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
