[excel] "rank" function from smallest to largest

Question

Hello,
In Excel 2000, I am looking for the formula that could help me establish the ranking of athletes "runners". I know the "rank" formula for ranking from the highest number to the lowest, but not for ranking from the lowest to the highest performance (since it concerns minutes and seconds in my case).
Thank you to those who can help me
Tinou

Configuration: excel 2000 windows 98

gbinforme · Accepted Answer

Hello

you're not far from the solution because:

=RANK(A1;A1:A20)
or
=RANK(A1;A1:A20;0)

gives the rank from largest to smallest but

=RANK(A1;A1:A20;1)
gives the rank from smallest to largest!

--
always zen

tinou · Answer

Hello gbinforme, How can one not stay zen with such clear, quick, and especially accurate responses....:-) Now that I know, it seems obvious. Thank you a thousand times, and have a great Sunday. Tinou

tinou · Answer

subject: equality in ranking  hi gbinforme,  you who helped me out so quickly this morning, could you give me another piece of info:  the ranking from lowest to highest is not quite accurate when it refers to a cell that contains the result of operations from other cells. so, during a staggered start for my runners, if in the end they have the same race time, excel does not put them in equal standing but takes into account the start time and gives a "rank" advantage to the one who started first. is there a trick? it's hard for me to express what I'm looking for. I'm giving it a shot with you or other readers thank you I'll stay zen anyway....:-) :-)

isa · Answer

I know the "rank" formula! What I want is to determine only the top 3 in a list, without including the others.... Am I clear enough? Thank you in advance.

gbinforme · Answer

Hello Isa  What I want is to determine only the top 3 in a list  =LARGE(list;1) =LARGE(list;2) =LARGE(list;3)  With these three formulas, you should have your three medalists. --  Always zen

ledieu · Answer

=rang(number;reference;order) order: 0=descending=from largest to smallest  1=ascending=from smallest to largest

valsero · Answer

Hello, I am a student and I have gaps in the formulas regarding rank and mention in Excel exercises. Thank you in advance.

[excel] "rank" function from smallest to largest

7 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.