Select/Sort Hierarichal Data in worksheet

S

S. Sakthivel

Hi,

I need to Filter or Sort out the Hirearichal Employee and Manager
information from below sample data structure.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20


I want the Sorted/Filtered Data as per below.

Empno Ename MGR Deptno
104 D 10
102 B 104 10
103 C 102 20
105 E 103 20
101 A 105 10

Kindly help me how to do the above in MS Excel 2003?
 
S

S. Sakthivel

Hi Socko,

I have the data in my worksheet as per below.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20

I want to make filter the above data as per below model(Hirearichal). i.e. I
need to display the above data from the top manager grade to lower. Here top
manager is 104. Because he is not working under any Manager. Also you can
employee 104 is working under the manager 104. And 102 is manager of employee
103...

Empno Ename MGR Deptno
104 D 10
102 B 104 10
103 C 102 20
105 E 103 20
101 A 105 10

Kindly help me how to filter the data as per my explaination.

Thanks & Regards,
S. Sakthivel
 
S

S. Sakthivel

Hi Socko,

I have the data in my worksheet as per below.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20

I want to make filter the above data as per below model(Hirearichal). i.e.

If i filter the MGR field is "104" means, it should come as per below.

Empno Ename MGR Deptno
104 D 10
102 B 104 10

Kindly help me how to filter the data as per my explaination.

Thanks & Regards,
S. Sakthivel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top