Forum Discussion
Excel - Sorting hierarchical numbers issue
Hi - I'm looking for some help with something I thought would be quick and easy but is proving not to be the case! I'm trying to sort a data set of hierarchical numbers but am having issues with ...
Let's say your hierarchical numbers are in B2 and down.
Change the formula in C2 to
=LET(n, C2, p, FIND(".", n), IFERROR(1000*LEFT(n, p-1)+MID(n, p+1, 10), 1000*n))
Fill down.