Rank Your Excel Data with the RANK Function

  Рет қаралды 138,173

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

Пікірлер: 18
@notmebutyou8350
@notmebutyou8350 2 жыл бұрын
Love your videos!! Thank you for uploading. ❤️
@crystalmendoza8140
@crystalmendoza8140 10 ай бұрын
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?
@marslexicon
@marslexicon 28 күн бұрын
im wondering as well
@Cloveron6487
@Cloveron6487 2 жыл бұрын
Good tutorial I love it
@lawrencekazibwe9751
@lawrencekazibwe9751 2 жыл бұрын
Thanks boss, it has been very informative
@yesplease6399
@yesplease6399 11 ай бұрын
But how do we fix the skipped numbers?
@smartexforex
@smartexforex 2 жыл бұрын
absolutely amazing
@FaithBulimo
@FaithBulimo 2 жыл бұрын
Love your videos!! I would love to know more on how to create an electronic filling system from the begining
@Travel_HUB_Memories
@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
@AkshayKumar-xg5wv 4 ай бұрын
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.
@oscardulcey
@oscardulcey 3 ай бұрын
Gracias por compartir conocimiento...
@mouhanadalazem8339
@mouhanadalazem8339 2 жыл бұрын
Thank you شكرا لك
@crazehaze35
@crazehaze35 5 ай бұрын
I would like to have that function work on a Row and not Columns. is there a way?
@aryanraj8111
@aryanraj8111 2 жыл бұрын
Hey! Why you are not using absolute cell referencing.
@starzforever7905
@starzforever7905 11 ай бұрын
It keeps giving me errors
@bradensadler2145
@bradensadler2145 4 ай бұрын
Skill issue
@y-phi148
@y-phi148 11 ай бұрын
HOW WOULD YOU RANK BASED ON THE GRADE LEVEL? 🤔
@GaneshBora-bb5ox
@GaneshBora-bb5ox 3 ай бұрын
The degree to which s.b.s.t.h. is.of.high.quality
Excel Functions to Help Fix Bad Text
6:31
Technology for Teachers and Students
Рет қаралды 16 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 8 МЛН
RANK function in Excel and Rank by groups by Chris Menard
5:40
Chris Menard
Рет қаралды 93 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 288 М.
How to Calculate a Rank in Excel (Descending / Ascending)
4:25
Excel Tutorials by EasyClick Academy
Рет қаралды 368 М.
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 592 М.
Using the Excel SUBSTITUTE Function
9:01
Technology for Teachers and Students
Рет қаралды 52 М.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 382 М.