Question: I have table including on Coulmn A : Number : 1 , 2 , 3 , 4 On coulmn B Names: khalid,nora,turky,hind When click on

I have table including on Coulmn A : Number :1,2,3,4
On coulmn B Names: khalid,nora,turky,hind
When click on header of column B names and select :hind it show me on column A number 4
I dont want that i want to show me 1 deepened on number that section from names
If nora and turky and hind it should show me 1,2,3 not 2,3,4 when clear the filter from names it back to 1,2,3,4 and coulmn B khalid,nora,turky,hind
How can do it on excel and idont have filter function please I need it to be correct

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!