My data will change, therefore I am using dynamic lists. Sorting needs to be dynamic as well. I do not want to click on the built in sort function.
I'm sorting dynamic data by formula, but it fails when the sort data is the same. For example:
A B
Marham 240
Sigonella 400
Toulon 400
Ghedi 150
Lajes 2000
Nordholz 400
Sorting by column B and returning column A values, the result should be:
Lajes 2000
Sigonella 400
Toulon 400
Nordholz 400
Marham 240
Ghedi 150
Note: I don't care about the order of the duplicated values among themselves (the "400"s).
With this formula:
{=INDEX($A$1:$A$6, MATCH(SMALL(COUNTIF($B$1:$B$6, "<"&$B$1:$B$6), ROW(1:1)), COUNTIF($B$1:$B$6, "<"&$B$1:$B$6), 0))}
The results are:
Lajes 2000
Sigonella 400
Sigonella 400
Sigonella 400
Marham 240
Ghedi 150
The MATCH
is tripping me up. How do I get around this?