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?
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??
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.
Love your videos!! Thank you for uploading. ❤️
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?
Love your videos!! I would love to know more on how to create an electronic filling system from the begining
Good tutorial
I love it
Thanks boss, it has been very informative
Gracias por compartir conocimiento...
absolutely amazing
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??
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.
Thank you
شكرا لك
I would like to have that function work on a Row and not Columns. is there a way?
But how do we fix the skipped numbers?
Hey! Why you are not using absolute cell referencing.
It keeps giving me errors
Skill issue
HOW WOULD YOU RANK BASED ON THE GRADE LEVEL?
🤔