Posts by suncluster

Re: Sort With Formulas

Is there a better way to carry out this task?

My intention using this formula was not to sort the data but to rank it.

My data:
a b c d e f g h
Bob Ted Alice Jay Fran Jack Average "Dept Priority"

every line item (1,2,3,...) refers to a specific project
Columns A-F list the comittee members personal ranking of the project
Column G is there average rank using the formula below
=AVERAGE(A6,B6,C6,D6,E6,F6)
Column H is meant to rank based on the averages
=COUNT($G$6:$G$80)-(RANK(G6,$G$6:$G$80)+ COUNTIF(G6:$G$6,G80)-1)+1

Then, I sort the data in ascending order.

I have a list in rows where I have a ranking formula

=COUNT($G$5:$G$81)-(RANK(G5,$G$5:$G$81)+COUNTIF($G$5:G5,G5)-1)+1

When I sort the rank, ascending. All of the unique numbers sort ascending, but the non-unique numbers sort descending

ex) 1.75 1
2.5 2
3.75 3
4 18
4 17
4 16

how do I sort the entire list in ascending order?