Range sort with numerical ranking


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
 
Ad

Advertisements

J

Jacob Skaria

In Cell A3

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

and copy the formula to the right...

If this post helps click Yes
 
B

Bernard Liengme

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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top