ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort an outline without changing the hierarchy (https://www.excelbanter.com/excel-discussion-misc-queries/169119-sort-outline-without-changing-hierarchy.html)

lelisabeth

sort an outline without changing the hierarchy
 
How do I sort an outline without changing the hierarchy of the outline.
Hidden items stay in the same rows and visible items sort without regard to
the level.

Pete_UK

sort an outline without changing the hierarchy
 
Maybe in a helper column you can have a code to maintain your
hierarchy, eg the first item could be 1.0, then subsidiary items are
1.1, 1.2, 1.3 etc, with the next item set at 2.0, and so on. Then you
can sort on this column.

Hope this helps.

Pete

On Dec 10, 7:20 pm, lelisabeth
wrote:
How do I sort an outline without changing the hierarchy of the outline.
Hidden items stay in the same rows and visible items sort without regard to
the level.




All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com