very helpful bro and i subscribed your channel too.THANKSSS.
@FamiHow
Жыл бұрын
Thanks and welcome
@otutom9362
5 ай бұрын
Appreciated
@tarinderkaur7621
Жыл бұрын
Thanks for this video
@FamiHow
Жыл бұрын
Most welcome
@cyrusstraus6908
Жыл бұрын
nice bro thnx
@FamiHow
Жыл бұрын
Welcome
@LubnaKhan-ob4hf
Жыл бұрын
Wow nice work
@FamiHow
Жыл бұрын
Thank you! Cheers!
@mercyjoannavanderpuije7799
Жыл бұрын
Thank you
@virtual0202
Жыл бұрын
Thank you
@primrosemuzhizhizhi83
Жыл бұрын
Thank you
@atifmehmood1985
11 ай бұрын
Hello sir I am Atif from Pakistan. I have asked the question many Excel Experts but none could reply. For example date is as following 1 Ali obtained 456 2 ajmal obtained 234 3ahmed obtained 235 4 wasim obtained 456. Now the obtained marks of Ali and wasim are same. If we apply rank formula we get positions as Ali. 1st Wasim. 1st Ahmed. 3rd Ajmal. 4th. 2nd is missing.
@FamiHow
11 ай бұрын
I will try to make a video on this topic
@otutom9362
5 ай бұрын
It’s correct. If two people are first, there will be no second. There is a tie. If three people were first, it would have been 1st, 1st, 1st, 4th.
@opabdulgamer440
11 ай бұрын
Aghar 1st position double aye to per 2nd position show nae karta darek 3rd position per show karta ha
@zee_ki
Жыл бұрын
Why do we put the dollar sign
@suseela6034
4 ай бұрын
Remarks is fail but rank is 10 pls check it and rectify it
@FamiHow
4 ай бұрын
Excel just ranks values from lower to higher.
@InternalAuditRM
Жыл бұрын
this formula did not apply on the following data. 250,260,281,281,0,200 in this example this formula does not read duplicate value. duplicate value should be assigned same position but it does not work properly.
@Griffaaah
Жыл бұрын
Did you solve that already? I am looking for a solution for that problem aswell :(
@shreyanshkhaitan572
Жыл бұрын
@@Griffaaah Same Let me know if u find a solution
@jaajaa455
Жыл бұрын
Samehere
@arslanliaquat6902
15 күн бұрын
You have to put $ sign before and after the l like =RANK(K7,$k$7:$k$16) It will works perfectly insha'Allah
Пікірлер: 30