Documentation

What is it?

With the Hierarchy Based Sort utility you can sort a list in Excel based on hierarchy (i.e. parent/child) relationships.

View Demonstration Video


Utility Definitions:
General
Column Row:
The row that contains the column header names

Data Start Row:
The first row of the list to sort

Data End Row:
The last row of the list to sort


Sort Settings
Item Column:
The column that contains the list of the parent and child names. Toggle ascending or descending for the desired sort result.

Parent Reference Column:
The column that contains the list of the parent and child names.


Top Level Column
Top Level Column:
The column that contains the name of the top item name in the hierarchy list. This is utilized when more than one hierarchy list exists within the same worksheet in order to sort/place the items in their correct hierarchy list when sorting. Toggle ascending or descending for the desired sort result.


?
Select the ? button to view this documentation page

Apply
Select the Apply button to sort the hierarchy list while maintaining the Hierarchy Based Sort dialog

OK
Select the OK button to sort the hierarchy list but also exiting from the Hierarchy Based Sort dialog

Software

Compare

Text Editing

Content Analysis

Files

Hierarchy

Filter

Utilities

Videos - YouTube

Contact Us

Still have questions? Contact us.

© 2024 Thinking In E, LLC. All Rights Reserved