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?
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?