I have an array that will have 10 numbers in it. Within these numbers, there could be zero values as well as duplicate values. For example:
1) 0
2) 30
3) 50
4) 0
5) 20
6) 30
7) 20
8) 0
9)100
10) 90
I need to be able to sort these using a (array) formula in ascending order, including duplicate and zero values. For example, from above, the order would be:
1,4,8,5,7,2,6,3,10,9
I know about "rank", but this does not help me with the duplicates. Any help would be appreciated.
Thanks!
1) 0
2) 30
3) 50
4) 0
5) 20
6) 30
7) 20
8) 0
9)100
10) 90
I need to be able to sort these using a (array) formula in ascending order, including duplicate and zero values. For example, from above, the order would be:
1,4,8,5,7,2,6,3,10,9
I know about "rank", but this does not help me with the duplicates. Any help would be appreciated.
Thanks!