Hello OzGrid,
I have a lot of values in a column such as 570, 850, 77, -44, 87, 90, -740.
I'd like to sort them with a formula but couldn't figure out how it'd be done.
Important point: these numbers must be listed as follows: 850, -740, 570 and goes on. Although it is a negative number, "change value" is essential for my report; that is why it follows 850 in my list.
I am aware of pivot or similar solutions but I would like to manage it with a formula.
Any help will be appreciated.
Onexc