Range sort with numerical ranking

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

If I have these #'s in these days....

1 Sat Sun Mon Tue Wed Thu Fri
2 29 138 18 177 139 150 169

3 6 5 7 1 4 3 2

How can I give the Max #1, the Min # 7, and the proper rankings/places in
between ? ( row 3)

Thanks,

Steve
 
In Cell A3

=RANK(A2,$A$2:$G$2)

and copy the formula to the right...

If this post helps click Yes
 
I will assume that "Sat" is in A1, and 29 is in A2
In C3 enter =RANK(A2,$A$2:$G$2)
Copy across the row
best wishes
 
Back
Top