How to Rank Items Using Excel RANK Functions

June 29, 2020



Check out my Blog:

This video shows you how to rank a list of values. It show three different functions to do this: RANK, RANK.AVG and RANK.EQ. There’s also some extra on how to use the VLOOKUP and create a dropdown to save extra space.

Feel free to provide a comment or share it with a friend!

P.S. I have other videos on how to use some of the other features highlighted in this video.

VLOOKUP –
Create a dropdown –

#exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

———————
Excel Training:

Excel Books:

Nguồn: https://mensagensdamanha.com/

Xem thêm bài viết khác: https://mensagensdamanha.com/cong-nghe/

All Comments

  • Thanks for helping me with my homework!

    Wabasha June 29, 2020 1:30 am Reply
  • This works on MS 360 … TNX BTW

    Fritz GG June 29, 2020 1:30 am Reply
  • Thanks. But I keep getting an error as I have "Absent" in the range. My principal doesnt want a zero, she wants "Absent.: Any work arounds? Sorry for the inconvenience. Thank you.

    Christianne Seeram June 29, 2020 1:30 am Reply
  • Where is d rank 3

    chetan Pal June 29, 2020 1:30 am Reply
  • What is there are more than 1 duplicates? I have a score here with 7 duplicates.

    Christy Petiluna June 29, 2020 1:30 am Reply
  • Thank you so much! very helpful 🙂

    Kelly VL June 29, 2020 1:30 am Reply
  • unlogical, a real rank will not have duplicates

    philipjLA June 29, 2020 1:30 am Reply
  • how to get the rank 9 position?????

    Atha Ullah June 29, 2020 1:30 am Reply
  • i love the way , you deliver this lecture , thanks alot for educating us

    Muhammad pak June 29, 2020 1:30 am Reply
  • Thanks for this……………………………

    Thisas Sumanasekara June 29, 2020 1:30 am Reply
  • Thx god bless u

    Chicken Wings June 29, 2020 1:30 am Reply
  • My rankings are incorrectly ordered. Can you help me fix it?

    Kevin Smith June 29, 2020 1:30 am Reply
  • Thanks for the video

    Syed Muzammal Muhasin June 29, 2020 1:30 am Reply
  • Thanks

    Kazi Masud June 29, 2020 1:30 am Reply
  • =ran(L5,$L$5:$L$42) this formula Mine displays it like this #####
    after punching ENTER. plz write formula

    md rasel June 29, 2020 1:30 am Reply
  • if data contains same value for multiple times,hw to find rank of the no. next to multiple data

    Anand Bakre June 29, 2020 1:30 am Reply
  • Mine displays it like this #N/A
    after punching ENTER

    L.G. Maquirang June 29, 2020 1:30 am Reply
  • wat shld i press instead of f4 because everytime i pressed it wont change to dollar sign???

    Miles Labios June 29, 2020 1:30 am Reply
  • i have enjoyed a lesson

    frank mwagongo June 29, 2020 1:30 am Reply
  • About to break my computer, been on 5 diff tutorials and I can not get this to work. About to really spend 3 hrs ranking this shit

    Brandon Myles June 29, 2020 1:30 am Reply
  • excellent tutorial for rank in excel Doug H sir…..

    GEO LEARNING June 29, 2020 1:30 am Reply
  • Really good presentation and information regarding Rank…

    shahid mahmood June 29, 2020 1:30 am Reply
  • It would be logical if you would show how to get the rank 9 position.

    paulo jansen June 29, 2020 1:30 am Reply
  • Does writing macros from code by writing code require use of an installed package?

    Restated is there a macro-editor which is a code editor as built-in to the product? 

    I hope to train an office-person on how to make the tool productive, usually I write in Java.

    Nicholas Jordan June 29, 2020 1:30 am Reply
  • Thanks for the rank video!!!

    ExcelIsFun June 29, 2020 1:30 am Reply

Leave a Reply

Your email address will not be published. Required fields are marked *