Question: I have table including column A is number from 1 to 1 0 and coulmn B is names ofstudents are sara , nora , hind,laila,hana,maha,wasf

I have table including column A is number from 1 to 10and coulmn B is names ofstudents 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: like hind and noh the coulmn A are 1.2 not 3,10 when not filter the names or coulmn C it back to 1 to 10 on column A number
How can do it on excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!