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?