Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add a rank column to the front so that it will start from small to large by index B:
But I use the formula:=aggr(rank(sum(indexB)),Code)
But the result is the below, the values are sorted from largest to smallest:
How can I write the formula to sort from small to large?
HI @Nora104
Try like below
=aggr(rank(-sum(indexB)),Code)
HI @Nora104
Try like below
=aggr(rank(-sum(indexB)),Code)