Find the rank of a number

[azidrane]

Pretty basic, but a cunundrum non the less.

List of teams and a stat beside them. Such as:

Team Name Wins
Team1 299
Team2 314
Team3 349
Team4 325
Team5 335

In a differnet cell i want to display the rank of team 4. In this case
it would be 3rd place, or third largest number.

Any Clues?

 

[AlanD]

Pretty basic, but a cunundrum non the less.

List of teams and a stat beside them. Such as:

Team Name Wins
Team1 299
Team2 314
Team3 349
Team4 325
Team5 335

In a differnet cell i want to display the rank of team 4. In this case
it would be 3rd place, or third largest number.

Any Clues?

 

[AlanD]

I suggest that you simply sort the data by Wins (Descending) and then
rank the results from top to bottom. If you want the teams in the
original order resort all of the data (including your ranking) by Teams
(Ascending).

Alan

 

[Jeff Standen]

There is a function that will do this, but it's a quite obscure name so I'm
not surprised you didn't find it in the help.

It's RANK.

Jeff

 

[Graham Whitehead]

Forgive me if this is not what you meant. however, suppose that 'team1' is
in cell A2 and the wins from team 5 is in cell B6. Now to get the rank for
team 4 put this into an empty cell:

=RANK(B5, B2:B6)

This should return the value of 3 in the cell.

 

[azidrane]

Jeez,
Rank. I should have guessed.
Oh well, we all have dumb days.

Thanks for all your help!

Cheer!