Excel Tips for Teachers Episode 3: Ranking results in Excel

[@_Manimal_]

After watching about 6 to 10 videos . . This one was perfectly done. Thank you

[@wesleyonyango-k2o]

You were blessed SIR,may GOD protects you

[@israeliseoluwa6704]

You're are a good teacher! Thanks for this!

[@matthewrobinson9356]

you are good at explaining, every needed details are provided. thank you!
I watch like 5 other videos before and was still not getting it correct until I watched yours. Thank you so much

[@eliaschitimbe6015]

Indeed I also did the same until this one poops out🎉😊

[@JakesKRulez-c6g]

This is good teaching ❤❤😊

[@may-fafafarmsclothing30]

Thanks for taking your time to explain everything.

[@margaretwangari7156]

This has truly helped me to remember alot

[@JakesKRulez-c6g]

Thank you for the lesson

[@olitaoyuka8179]

So clear and useful! Thank you very much.

[@rachnasingh9984]

Thank you so much! It was really helpful.

[@JonathanBoadu-ip7td]

Thanks 🙏 very much for your good explanation

[@ndongetheldredabih3405]

Thanks very much. Really helped me.

[@preciousdidam511]

Thank you,it was very helpful to me❤❤

[@monicabae8228]

you are good at explaining, every needed details are provided. thank you!

[@berniceoyere5693]

Wow thanks so much, I now understand where I was making errors

[@maizatulrahaman1061]

wow this is very good! Thanks!!! very good explanation, not only you share how to, but why.

[@srinub5979]

Among the most of same videos you are the best sir thank you

[@asunachihiro4457]

Very well explained. Thank you so much

[@cheruiyotkirui7953]

Sir,what if I have tests for every subject(C.A.Ts and end term exams), I want to calculate their average score at the end of the term .what should I do?

[@yareddemssie1692]

It helped me learn calculating rank in excel very fast. Thank you

[@MariaKhan-lg8pg]

Hey thanks a lot! This was really helpful :)

[@lalinram1438]

Thanks alot.. we'll explained

[@mrosevmin7249]

Thank you so much. I'm always having a hard time in ranking.

[@annijaugen9094]

I tried and made it..wow thankyou

[@lansanak.kerrah6251]

Thank you Sir, this is very helpful to me

[@cherrypinksilagan4984]

Great help. Thanks.

[@kachymaura]

Thank you....its very helpful

[@Gespetio]

how do you add the st, nd , rd after the numbers?

[@govindakhatiwada231]

Can i make that rank 14 to 14th automatically and same as to other?

[@DrinkCola]

yes you can just add + "th" after the formula and press enter

[@abdulkareemfakhi3086]

Very nice❤

[@pamelajacar4216]

Thanks for the great help!

[@satyabanukil779]

Good tutorial. However I feel MS Access (another Microsoft package) can store data more efficiently, shall be thankful if ranking illustration can be taught in MS Access form level.

[@robertralte683]

I am making a student marksheet in rank column i dont want the rank for fail student

[@ruthlalsangmawii3222]

im in love with your voice

[@marinielcortina4570]

Thanks for this

[@udennyn]

After 6th its reflecting 9th rank. Where are 7th and 8th ranks?

[@pixiedustdhias9275]

thank you for this ❣️

[@edisonbizimana9470]

Helpful☺️

[@khansvirtualdiary]

excellent Interface

[@parthisjilla548]

thank you so much help full my job

[@joonnam501]

Hi, I have a question in " Excel Tips for Teachers Episode 3: Ranking results in Excel ". Admission #411and 412 are same rank with same total and %score, if I want to make #412 higher ranking than #411 because #412's writing score is higher so this case #412 is 6th place and #411 is 7th place, is this possible ?

[@DrinkCola]

you should add more decimal places to your score number

[@domtesil]

I can’t see the 3rd, 7th, and 8th Ranks in your video.

[@dynatae]

watching in 2020 lmao!

[@saadanwar2688]

38 to 1
34 to 2
33 to 3
33 to 3
32 to 4
31 to 5
how get the above ranking ???
thanks in Advance

[@teachproftunmore]

Hi Atha, there is a third criteria in the function called [order]. Use a 1 here for Ascending order, or a 0 for descending order. So =RANK(A2, $A2:$A20, 0), for example.

[@muhammadsaqibshah7891]

@@teachproftunmore it is missing 4th position

[@muhammadijaz9978]

In your case if you have same 2 rank you will not find 3rd rank similarly you have tripple 6rank then you will not get the 7th or 8th rank it will go to 9th rank insteadh

[@ewoenamfranca1044]

I enjoyed my lesson

[@eliaschitimbe6015]

Thanks alot

[@srinub5979]

Wow thank you sir

[@clydemhessinga4918]

Thank you

[@jigyasadhakal5763]

where's the 3rd rank?

[@kathy-annwilliams7854]

thannnnnkkkkk Youuuuuuu

[@cas9954]

Thanks

[@justsomedude7083]

thank u

[@zumoke5951]

Notice how Justin Beiber has a 2.5 score😂

[@xennhyun3526]

you talk to much just go to straight to the point!

[@crizielnatividad4265]

Thank you

[@samithmshaji5589]

where is the 3rd rank ?

[@layuhangma1242]

Where is second rank?