Posted 8 September 2017, 2:17 pm EST
I have spread with 3 levels of hierachical data. I have header visible only for to of the parent column. i want to sort all the levels of data in one column. based on sorting i want to assign ranks in another column.
In the screen shot i have marked a column in red colour. In that i want to sort the values in ascending after sorting that column based on sorting i want to assign sequential values in another column.
Kindly help in this issue.
Thanks in advance,