MS Excel 2010 Tutorial - Use a Formula to Rank Scores in Excel

Want all of our free Excel videos? Download our free iPad app at itunes.apple.co...
www.ifskills.co... This Excel 2010 Tutorial shows how to use a formula to rank scores in Microsoft Excel 2010. Authored by a Microsoft Expert, this training video is just a short extract from the full 9 hour course. Visit our website to view the tutorials in a far higher resolution. KZbin: / oreillymedia
Facebook: www.facebook.c...
Twitter: / oreillymedia
Website: www.oreilly.com/

[@OfficialMoin]

What if 2 students have scored equal number of marks?

[@rizwankausar6741]

Thank you very much May Allah bless you

[@shreyashagrawal2264]

what if two students have same scores. How will we differentiate then

[@farooqtaj6811]

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

[@ElinaMaree]

What happens if my students scores are not out of 100? And I want to record spelling results (for example) in each cell e.g. 20/25 (20 correct out of 25). Excel keeps changing it to dates/fractions/various other things...please advise.

[@tauseefullah6068]

Sometime dual no appear in rank. Then it miss a no... Fore example 2 students have 98 marks and 1 student got 97.. excel will rank both 98 marks on 1 and 97 on rank 3 What is the solution

[@sammykalintosh5630]

Thank you very much but how do I get to arrange the student's by rank - automatically?

[@sinhala-monami3954]

it worked. it also worked for web app. Thank you very much

[@Copyrightbreaker22]

it's really good if only I had the english version of excel and not the dutch version lol

[@robertdelacruz6052]

Hi! I would like to ask if this could still be used if there are variables with the same rank? Thanks!

[@mamtabatra3753]

Thanks for teaching me how to find rank of the students in a class, I was struggling to get it.

[@avn33__44]

After completing the rank function why is it showing #N/A for many cells? I can't find the rankings due to this prob

[@lijamsolomon7921]

that is wonderful, i appreciate

[@bhavyasrivastava212]

Thankk u sir it is very useful to learn from this

[@goldngozi8897]

Thank. This is very helpful...

[@saadanwar2688]

38 to 1 34 to 2 34 to 2 32 to 3 Is there any method to get the ranks as above? Thank you in advance.

[@idrisolatundex4160]

There is confusion yeah 4 student have same percentage why is the rank now different

[@mahmudulhasan5754]

Can you give me this Excell sheets, please?

[@digicom849]

thank u for clear information

[@satishsatish6358]

Thank you so much

[@brucktube8764]

thanks a lot love from ethiopia

[@pallavisinghchandansingh9203]

Thank you so much you done a little thing but it is very big to me I am very happy that I cannot expresses because for this task I was searching for more than 2 hours 😘😘😘🥳🥳

[@anthonyr3624]

Much thanks, this vid really made me shine when i created a report which ranks our down-trace based on their metrics

[@bon_journal]

Thanks very much. The dollar sign is what I'm looking for. I can't just press F4 since it closes my excel. :)

[@adityaagarwal7172]

Press fn + F4

[@dayesolomon]

What if they are two 312 's how do you rank in position

[@jessonalbaran8538]

I always come here… MANY TIMES. Thank You. 👍👍👍👍👍

[@jessjess5036]

Thankyuuuuuuuuuuu........ 🤗🤗🤗🤗❤️

[@Ratidzai-j6o]

Your voice is too low, or am l hearing impaired?

[@nchimunyamweene]

Please you are the best sir ...😂😂😂😂thank you so much

[@rakibsarker2070]

I want to limit position... How do it?..like first 10 th person rank...

[@anandbakre5532]

give formula if data contains same value for multiple times

[@nabahanshehu6190]

very much helpful

[@LenvicaHRMS]

Great tutorial! Thanks.

[@uwiduhayeclemence5907]

I was struggling and asked all of my fellow teachers but not getting the answer , but now l' m satisfied

[@rajesharya8187]

Stunning, many thanks

[@SyedKollol]

this formula don't work if you have multiple value which are same...

[@saadanwar2688]

38 to 1 34 to 2 34 to 2 32 to 3 Is there any method to get the ranks as above? Thank you in advance. yes but how to solve it?

[@rollme-wankenobi7208]

Baba O'Reily youre a fuckin hero

[@nakiguddeoliver4760]

Thanks, this video has been helpful

[@OlusegunvictorAyokunle-lq7wd]

Thank You, I do appreciate this

[@HOUSEOFFAME-h6p]

Thank alot dear🙏🏿🙏🏿

[@Chandiram-cu7km]

How to find any scores

[@nijuyonkadesu]

woah man! life saver

[@SuperRome18]

Thanks you save me

[@maradybonjour9779]

Fast and easy guide.Thanks

[@Niyati089]

How was the dollar sign added ?

[@mangalsah9220]

राम राम

[@vannakpisal]

Thank you❤🎉

[@tishacomputerphotocopy1839]

What to do when the total mark is equal?

[@paridohare128]

Siemens 3 HP ki motor ki jankari gas

[@TheRishmalik]

very nice sir

[@rhrmentor1367]

nice way of teaching.

[@wwssr]

thank 🧒 🧒

[@brightafricapsbaps465]

So nice

[@jagmen4002]

no name

[@belewyigermal9575]

Sorry

[@gurusakiwrites666]

Very helpful. Thanks.

[@jubairbinhussain8205]

how to add 1st 2nd 3rd

[@divinabernaldez5581]

Thank you so much🙂

[@narband2778]

clearly explained.... liked it....

[@cyberpunk7088]

i need to count absent student also.. how do i do it?

[@cyberpunk7088]

i figuered it out.. :p

[@mukeshjha637]

How to do raking in order

[@snorewak]

thankyou for this!

[@jerrynamaka8539]

Siradanishi

[@dyaluguru5210]

Ek no ka fuke formula hai

[@mwimasam6514]

very interesting keep it up

[@chikabells5296]

Thanks Professor❤️

[@farhannaufal9409]

United states 2020

[@abdullahkhidir1320]

good

[@rajeshkhadgi1561]

Thank u.

[@CalvinMungoma-vf8ti]

Love it

[@rv6130]

Thank you

[@sajjadanawabi4760]

it is good

[@nureenfaihanah6546]

Thank you soo much, this saved my dissertation!

[@shani463463]

Thanks........!

[@beenakhan9524]

very nice

[@shabanmwindadi3072]

Amazing thank you

[@SophyFingermi]

HEllo guide bus me back

[@belizeangial1970]

AWESOME

[@mithunkumar388]

Hi

[@Sharnjit173]

nice

[@mussawirshah913]

Thank you

[@RiyazKhan-nc1uc]

best

[@001srk]

thanks

[@HaRacycEBLErAtIng]

Thank you it helping so much for me

[@vigneshk8750]

THANK U

[@mdrasel-jb1zv]

plz write reply formula plz

[@blogmind3209]

what do you mean reply formula?

[@giocabuntocan673]

Thank you very much! Worked like a charm! 🔥

[@crystalcristopher1784]

OMG, EXACTLY WHAT I NEEDED -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- i got resources from 💜 BEGA.BAR/GVGTYG 💜

[@lukyxeddu73]

OMG, EXACTLY WHAT I NEEDED --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- i got it from 💜 *O.YOBY.BAR* 💜 *"**8:25**"*