ranking cells in excel

[Guest]

I have only a basic knowledge of excel and I am trying to use the rank formula.
I have a column that has data for 2 types of items. I want to rank each
type separately. I have tried putting in the rank formula, but it doesn't
seem to want to take specific cells as the ref.
example:

team 1
weight 119
steps 24

team 2
weight 210
steps 8

team 3
weight 106
steps 14

In the next column I want to rank the weight and I want to rank the steps
separately. Is there a way to do that?

I also need to know if I can rank precentages? If so, please let me know how.

Thank you in advance for your help.

 

[Nigel]

RANK(value,range,order)

If the weight values are in column B from row 1 to row 10 and you require
the highest value to be rank 1 then use

=RANK(B1,B$1:B$10,0)

If you wish the lowest value to be rank 1 then use

=RANK(B1,B$1:B$10,1)

In all cases copy the formula down from row 1 to row10

Ranking Percentages is no different - values of percentages are just numbers
displayed as a %.

 

[Mike Fogleman]

It sounds like you are having a problem entering a non-contiguous range in
the reference range. The cells need to be enclosed in parentheses, separated
by commas:
=RANK(B2,($B$2,$B$6,$B$10),0)
team 1
weight 119 =RANK(B2,($B$2,$B$6,$B$10),0)
steps 24 =RANK(B3,($B$3,$B$7,$B$11),0)

team 2
weight 210 =RANK(B6,($B$2,$B$6,$B$10),0)
steps 8 =RANK(B7,($B$3,$B$7,$B$11),0)

team 3
weight 106 =RANK(B10,($B$2,$B$6,$B$10),0)
steps 14 =RANK(B11,($B$3,$B$7,$B$11),0)

Mike F