[excel] "rank" function from smallest to largest

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

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

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....:-) :-)

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

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.

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