No video :(

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

Подписаться 147 тыс.

Просмотров 1 млн

50% 1

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. RU-vid: / oreillymedia
Facebook: www.facebook.c...
Twitter: / oreillymedia
Website: www.oreilly.com/

Опубликовано:

28 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 100

@jessonalbaran8538 Год назад

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

@sinhala-monami3954 3 года назад

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

@OfficialMoin 4 года назад

What if 2 students have scored equal number of marks?

@rizwankausar6741 2 года назад

Thank you very much May Allah bless you

@brucktube8764 3 года назад

thanks a lot love from ethiopia

@mamtabatra3753 4 года назад

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

@jessjess5036 Год назад

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

@goldngozi8897 3 года назад

Thank. This is very helpful...

@nchimunyamweene 8 месяцев назад

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

@shreyashagrawal2264 3 года назад

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

@nakiguddeoliver4760 9 месяцев назад

Thanks, this video has been helpful

@bhavyasrivastava212 4 года назад

Thankk u sir it is very useful to learn from this

@anthonyr3624 4 года назад

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

@OlusegunvictorAyokunle-lq7wd 7 месяцев назад

Thank You, I do appreciate this

@maradybonjour9779 3 года назад

Fast and easy guide.Thanks

@digicom849 4 года назад

thank u for clear information

@divinabernaldez5581 2 года назад

Thank you so much🙂

@satishsatish6358 4 года назад

Thank you so much

@uwiduhayeclemence5907 3 года назад

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

@sammykalintosh5630 5 лет назад

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

@pallavisinghchandansingh9203 3 года назад

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 😘😘😘🥳🥳

@user-zn5st6oi7l 8 месяцев назад

Thank alot dear🙏🏿🙏🏿

@nijuyonkadesu Год назад

woah man! life saver

@robertdelacruz6052 7 лет назад

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

@vannakpisal 2 месяца назад

Thank you❤🎉

@rajesharya8187 3 года назад

Stunning, many thanks

@LenvicaHRMS 4 года назад

Great tutorial! Thanks.

@lijamsolomon7921 4 года назад

that is wonderful, i appreciate

@rhrmentor1367 3 года назад

nice way of teaching.

@TheRishmalik 2 года назад

very nice sir

@gurusakiwrites666 2 года назад

Very helpful. Thanks.

@nabahanshehu6190 4 года назад

very much helpful

@nureenfaihanah6546 3 года назад

Thank you soo much, this saved my dissertation!

@ElinaMaree 4 года назад

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.

@bon_journal 6 лет назад

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

@adityaagarwal7172 2 года назад

Press fn + F4

@SuperRome18 2 года назад

Thanks you save me

@brightafricapsbaps465 2 года назад

So nice

@saadanwar2688 6 лет назад

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.

@narband2778 10 лет назад

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

@avn33__44 5 лет назад

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

@chikabells5296 2 года назад

Thanks Professor❤️

@farooqtaj6811 5 лет назад

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

@snorewak 5 лет назад

thankyou for this!

@rv6130 3 года назад

Thank you

@Sdaye-on5ix Год назад

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

@shabanmwindadi3072 3 года назад

Amazing thank you

@anandbakre5532 7 лет назад

give formula if data contains same value for multiple times

@idrisolatundex4160 2 года назад

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

@Niyati089 3 года назад

How was the dollar sign added ?

@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

@mwimasam6514 8 лет назад

very interesting keep it up

@rajeshkhadgi1561 3 года назад

Thank u.

@rakibsarker2070 3 года назад

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

@beenakhan9524 5 лет назад

very nice

@Chandiram-cu7km 3 года назад

How to find any scores

@Copyrightbreaker22 4 года назад

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

@tishacomputerphotocopy1839 6 лет назад

What to do when the total mark is equal?

@paridohare128 5 лет назад

Siemens 3 HP ki motor ki jankari gas

@giocabuntocan673 2 года назад

Thank you very much! Worked like a charm! 🔥

@CalvinMungoma-vf8ti 11 месяцев назад

Love it

@wwssr Год назад

thank 🧒 🧒

@jubairbinhussain8205 3 года назад

how to add 1st 2nd 3rd

@mukeshjha637 4 года назад

How to do raking in order

@mahmudulhasan5754 5 лет назад

Can you give me this Excell sheets, please?

@abdullahkhidir1320 10 лет назад

good

@shani463463 12 лет назад

Thanks........!

@HaRacycEBLErAtIng 8 лет назад

Thank you it helping so much for me

@001srk 7 лет назад

thanks

@belizeangial1970 11 лет назад

AWESOME

@cyberpunk7088 5 лет назад

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

@cyberpunk7088 5 лет назад

i figuered it out.. :p

@SyedKollol 10 лет назад

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

@saadanwar2688 6 лет назад

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?

@vigneshk8750 7 лет назад

THANK U

@Sharnjit173 5 лет назад

nice

@sajjadanawabi4760 4 года назад

it is good

@mithunkumar388 5 лет назад

@RiyazKhan-nc1uc 7 лет назад

best

@rollme-wankenobi7208 4 года назад

Baba O'Reily youre a fuckin hero

@jerrynamaka8539 4 года назад

Siradanishi

@user-wm9st4nl6i 4 месяца назад

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

@SophyFingermi 6 лет назад

HEllo guide bus me back

@mdrasel-jb1zv 7 лет назад

plz write reply formula plz

@blogmind3209 3 года назад

what do you mean reply formula?

@farhannaufal9409 4 года назад

United states 2020

@mangalsah9220 3 года назад

राम राम

@jagmen4002 2 года назад

no name

@belewyigermal9575 3 года назад

Sorry

@dyaluguru5210 2 года назад

Ek no ka fuke formula hai

@crystalcristopher1784 2 года назад

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