Rank Your Excel Data with the RANK Function

[@crystalmendoza8140]

I feel like some info was missed. What are some solutions to fixing the numbers with the same rank? And what makes the EQ formula different from the Rank function?

[@notmebutyou8350]

Love your videos!! Thank you for uploading. ❤️

[@FaithBulimo]

Love your videos!! I would love to know more on how to create an electronic filling system from the begining

[@Cloveron6487]

Good tutorial I love it

[@lawrencekazibwe9751]

Thanks boss, it has been very informative

[@oscardulcey]

Gracias por compartir conocimiento...

[@smartexforex]

absolutely amazing

[@mouhanadalazem8339]

Thank you شكرا لك

[@yesplease6399]

But how do we fix the skipped numbers?

[@Travel_HUB_Memories]

Thank you sir... but Sir i have a question. u showed that it skipped some ranks when there are more than one in a same rank. but how do we exactly fix that so that it doesn't skip the proper ranks??

[@AkshayKumar-xg5wv]

Hi, I also was looking for the solution for not skipping ranks, which excel formula does by default. I got a solution and wanted to share it. Identify the maximum value in the column which you want to rank. You can use Max formula and lock the range. Then you can subtract the values in the column to rank with this max value. Just add 1 to avoid 0. There you go with the rank without skipping any ranks.

[@aryanraj8111]

Hey! Why you are not using absolute cell referencing.

[@crazehaze35]

I would like to have that function work on a Row and not Columns. is there a way?

[@starzforever7905]

It keeps giving me errors

[@bradensadler2145]

Skill issue

[@y-phi148]

HOW WOULD YOU RANK BASED ON THE GRADE LEVEL? 🤔

[@GaneshBora-bb5ox]

The degree to which s.b.s.t.h. is.of.high.quality