View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ramesh Ramesh is offline
external usenet poster
 
Posts: 19
Default Sorting based on Heirarchy or recursive

Hi Im totally new to Execl.I have a table which shows which emp is dependent
on his superior.I want to sort it hierarchially.

Example table is like this

EmpId Dependent ID level
A 1
C A 2
D A 2
F C 3
G F 4
H C 3

I need to sort This out so that the output table will be

EmpID DependentID Level

A 1
C A 2
F C 3
G F 4
H C 3
D A 2


Any help will be highly appreciated.Thanks a lot....