View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kcmtnbiker
 
Posts: n/a
Default Sorting Parent Child

Does anyone have any ideas on how to sort parent child records within Excel?
The child records may be up to 5 "levels" deep. I have two columns that I
can work with, RecordID and ParentRecordID. Here is an example of what I am
working with:

ID ParentID Item
1 0 General
2 1 TPP
3 1 Services
4 2 Food
5 2 Software
6 1 Consulting
7 5 Custom Software

I would like to be able to sort them so that they are in a "tree view" or
hierarch format so that all child records roll up to their respective parent.
Thanks.