View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Sort by Hierarchy

Presumably the parent key defines the hierarchy, so why not sort on
parent-key then child-key ?

--
Cheers
Nigel



"SpaceCamel" wrote in message
...
I have a list of data with a key and its parent key.
It is currently sort by key.

I need to sort by Hierarchy so that the children come after the parent.

Is there a algorithm to do this?
Would also need to determine the outline level.

Thanks,