top of page

Spreadsheet Tools with More Leverage

Sort NHA

NHA stands for Next Higher Assembly, i.e. 'Parent'.

If an NHA column exists and has been scrambled for whatever reason, the 'Sort NHA' function can help restore the table to it's proper structure.

For Example, consider the following scrambled table that has an NHA column.

Example Table with NHA & order scrambled

When the SortNHA function is utilized, the structure is restored.

Note: This will not necessarily be the original sequence, but every line item will 'tree-up' properly.

Example Table - After Sorting on NHA

bottom of page