# Excel RANK Function to Compare Numbers in a List

If you have test results, or another list of numbers in Excel, you could sort them to see

which scores are at the top, but if you want to leave the

list in its current order, you can use the RANK function to show the order of these scores. In cell C2, I’m going to create a RANK formula, and then copy it down to

the bottom of this list, and we’ll see which position

each student’s score is in. In cell C2, I’ll start with an=, and type RANK, R-A-N-K, and an (. The first argument is the number. I have to click on the

cell that has the number I want to find the rank for. In this row, it’s B2. I’ll type a comma. And then the reference, so what am I comparing it to? I want to compare it to

all the other scores. I’ll start at B2 and drag down to B11. Now I’m going to be

copying this formula down to all the other rows. As I copy it down, I want it to always change

the cell that it’s checking, but I don’t want it to change the cells that it’s comparing to. It should always be B2 to B11. While I’m at the end of this

reference that I just typed, on the keyboard I’m going

to press the F4 key, and that makes this an absolute reference so this won’t change as

I copy the formula down. And I’ll finish with a ) and press Enter. The score 46 is ranked 1, and I’ll click on this cell, and drag the fill handle down. We can see all the other ranks. In this cell, it’s now looking at B7, but it’s locked into that B2 to B11 range to check the rank.

Lady you ARE AWESOME! This is the second time you've helped me tonight with excel!

very easy get it now … thanks

That was very easy to understand, and very helpful. Thank you kindly.

great… thankyou

super. plz keep on uploads .heartly i thank u.

thank you for the video, you help me so much,>W<

great

hey Contextures Inc. where is 5th rank number? could you tell me please how to ranked properly ?

Very useful. Thanks for posting.

Very helpful, super easy to understand, Thanks!

Thanks for the extremely helpful video!

Thank you so much

thank you ma,am 🙂 i was trying but i guess i was missing to hit f4 and that's why i get wrong values again n again

Sorry. but it has some lacks. The 5th place(rank) is omitted. And that problem appears every time when we have repetitions of rank. For example: if you had 3 times rank 4 the next rank would be 7 (5 and 6 will be skipped).

anyone who knew the equivalent of the f4 key in libreoffice calc? We were instructed to only use calc

Great video, exactly what I wanted, so easy to understand. Well done and thank you.

perfection.

I AM LOOKING FOR SWIMMER TIMING FORMAT SO FOR EXAMPLE IF TIME 01:20.15 & 01:15.20 SO I WANT 1 ST PLACE FOR 01:15.20.

IF ANY ONE KNOW THIS PLEASE TELL ME HOW TO DO THIS?

AWESOME. Thanks.:)

thank you, this video was very helpful, Keep it up <3

Thank You

Thank you

Thank you. Very simple and well explained.

Dear its good but not actually, where is 5th position

I've been struggling with formulas for 3 days; I've purchased two books and spent time trying to follow them. Your simplistic but invaluable video is a blessing!!

Thank You So Much….

Thank you for this I did the formula and it worked. However when I dragged the formula down it gave me an error #N/A how do I fix the cells that have this but the formula in the bar looks correct?

Thank you for the help. Very helpful explanation.

Good video thanks!

Thanks for teaching me both the RANK function and the Absolute Range Function F4 shortcut. The Absolute Range Function F4 shortcut was a totally unexpected bonus that will save me tons of time!

THANKS FOR DETAILED EXPLANATION, I FINALLY UNDERSTAND WHY I HAVE TO USE F4

Thanks a lot !

Thank you for Upload this Video, Great Work Thanksssssssssssssssssssssssssssssssssssssssssss

the "F4" key doesn't work for me im on windows 10 2016 exel how do i do it manualy

How to identify the failure student? For exp if some students failed in one sub they should not be in the rank list.

Set the video speed to 1.5 , you can thank me later!

Thank you!

Thanks a lot

Extremely helpful! Thank you very much!

Ｇ✿✿d

It miss 5th rank in your video as well as in my PC

Thank you so much! You are awesome!

Thank you – very well done!

how about to make in other?

Thank u ✌️

Thank you !

Perfect explanations about that Dolore sign nd use thanks

Thanks

>_<

Very good explaination. Congratulations!

Hey can you tell me if i f no 30, 32, 20, 30, 40 if i arrange tham with RANK formula there is 40=1,32=2,30=3,30=3 than 20 is shift to Rank five. I want it remains 4. Can i ?? Please reply it really helps me

I like the way you explained it. Thanks!

is there a unit for critical value? like, how is it reported in research papers?

Very nice video

Thank you! I always forget how to do this!

thanks for share this video.

thank you it help me, but if you don't care can you send to me your E-mail address?

thanks

How can you Rank so that the smallest score would be ranked in first place?

Helpful video!

Thanks😊

Language smjh me na aati bus smjh jaya hoon vaise mai Very nice baby I like you voies

great info thanks

HELLO SIR, JAB JUM RANK NIKAL TE HA TAK AGAR SAME NUMBER AA JAYE TO EXA 11, 11 AGAR ENKI RANK MAAN LETE HA 4, 4 TO AGLI WALI YE RANK 5 KI JAGAH YE SIDHA 6 DIKHA RAHA HA KARAN BATANA SIR JI

where is 5th score, (5th position?)

Nice and clear, thank you.

Thanks for the video

Thank you 🙂

Isme rank 5 kha h

Thank u very very very much madam…😊

How can I then have the table reorganize to have the 1st person that is doing the best at the top of the list and have the rank in descending order from there?

It's very easy thank u mam

Thank you love

Thank you. Very clear explanation.

But when I press enter in that process it says you have entered too few arguments, and as your comp tells the rankings mine one doesn't tell the rankings, but it says, you have entered too few arguments

millions of tanks

Hi. Just subscribed to your channel. I have a question on ranking

and formatting. I would like to format cells e.g. A1, C1, E1 and G1

based on their ranks i.e from the lowest to the highest assigning colors

based on what is there. Kindly assist. Thanks

Thanku so much I hope u succeed in life and YouTube

I have faced a problem use rank function….

Problem:

When I find my ranking for A1:A5

A1.value =95

A2.value =75

A3.value =95

A4.value =90

A5.value =95

My answer is

(1,5,1,4,1)

I want it ranking continue

Like (1,3,1,2,1)

How solve it?

Thanks

So helpful!

I want to make a ranking from the first (highest score) to the last in a different list. In other words, I don't mind moving the names, I just want the positions. How do I do it? Can someone help me, please?

thank u so much for making this video

thanks a lot

my problem is about equal numbers,there is 2 name for 4,when try to result of rank on an other function,large function give ıvy or joe,how can i know them,one is joe and other ivy

Saved me so much time thankyou. Very well explained.

Not got clearly

That helped me … also knowing the function of pressing F4 I didn't know that and used to add it manually, thanks

Thanks

Thank You!!

Thank u

Where is rank 5

4 number ka rank 2 bar he iske bad 5 number kyu nahi aya

Yah problem ka solution nikal ke video banaye

so simple and help me a lot. thanks you

I press F4 not change like you. please help me

sooo helpful, thank you, thank you, thank you!

5 vi rank kha h

This function is exactly what i was searching for to complete my lotto syndicate frequency table. You halped iron out some of the snags in my formula. Awesome thanks.

I love it that there are no frills in your videos. Right to the point without lengthy introductions. The perfect length (under 3 minutes) makes them excellent for quickly watch them and learn or refresh one's knowledge. Great job!

Thank you very much!!!😁😁😁👍

Thanks, it was useful.

Where is rank 5?