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.
Hi - thanks for replying, I appreciate it. I've been on vacation so just picking it up now.
I changed the data format to text in column B and used the formula in Column C as so and it worked-
Many thanks for your help!