Hi there
I have an issue sorting grouped "parent" and "child" documents into date order as the "children" do not follow the parent when sorting.
I have attached an example Excel Spreadsheet. I want the Parent IDs to sort on the Date Column C but not the children IDs. I want the children to "follow" the parent when I sort the parents into date order.
These are essentially a index to emails with documents attached to them that have been put on a hard copy file, so physically they are arranged from newest to oldest, with attachments behind the parent email. Some documents have dates and some do not (although I could give them a nominal date to match the parent email date and time so as to work as a placeholder). Ultimately, I would like to be able to sort the entire list from oldest to newest and then "reassign" the document ID accordingly.
E.g.in the attached spreadsheet, when the sort function is used MRG00016 (dated 11 October 2013) and MRG00017 (undated) ought to sort before MRG0007 (24 October 2013) and MRG00008 (undated) but that does not happen.
Does anyone know how to make the sort function work so that the grouped rows follow each other?
Cheers
Mark.
Bookmarks