RANKIF Function: Ranking with Condition
In this video, I have explained in detail all RANK functions, which are #RANK, #RANK.EQ and #RANK.AVG.
Sometimes we need to get RANK based on our conditions, but we use manual methods or very complex formulas to do this. In this video, I have tried to solve this problem in a very easy way with the help of the #SUMPRODUCT function.
Must watch the video and learn the #RANKIF function and know how to get ranked based on conditions or criteria.
**********************************************
Subscribe to KZread & Follow on Dailymotion and Like Facebook Page👇
/ exceluniverse
www.dailymotion.com/exceluniv...
/ exceluniverse.in
Checkout Some Other Excel Tutorials Videos:
Count Unique Records with Multiple Conditions in Excel👇
• How to Count Unique Va...
Count Days between two dates👇
• Count Day of Week Betw...
Excel Dashboard Automation👇
• Excel Dashboard Automa...
How many Sundays are between the two dates?👇
• Count Day of Week Betw...
Calculate the Age in Excel👇
• DATEDIF Function in Excel
LAMBDA Function in Excel
• How to use LAMBDA Func...
No More IF Function || Move on SWITCH or IFS 👇
• Excel SWITCH Function
• IFS Function in Excel
Extract Number from Text without VBA👇
• Extract Numbers From T...
Know New thing of HLOOKUP👇
• Reverse lookup in exce...
#rank
#rank.eq
#rank.avg
#rankif
#rankifs
#sumproduct
#Excel
#ExcelTips
#ExcelTutorial
#MsExcel
#rankfunction
#excelranking
#ExcelUniverse
Download the Practice File Here 👇
mega.nz/file/Jyg1AABJ#9Mh-O9I...
Пікірлер: 32
thank u
@ExcelUniverse
Жыл бұрын
Most welcome 🙏
Very informative👍Keep going
@ExcelUniverse
3 жыл бұрын
Thanks a lot
Very helpful here. Tnx
@ExcelUniverse
3 жыл бұрын
Thanks for your feedback 👍
Great Presentation Sir
@ExcelUniverse
3 жыл бұрын
Thanks for your valuable feedback
Very nice explanation 👍
@ExcelUniverse
3 жыл бұрын
Thank you 😃
Great work
@ExcelUniverse
3 жыл бұрын
Dhanyawad Sir Jee,
Excellent..
@ExcelUniverse
2 жыл бұрын
🙂
great .
@ExcelUniverse
2 жыл бұрын
Thanks
Hello sir I need help to make formula in excel how to contact with you
@ExcelUniverse
2 жыл бұрын
Which type of formula you want
vey nice tutorial, please keep posting, you voice is low , please increase volume in you tube
@ExcelUniverse
2 жыл бұрын
Thanks for your compliment and suggestion, I'll try to fix it😊
it skips some number. how fix it sir. please help me.
@ExcelUniverse
3 ай бұрын
Can you please explain in detail exactly what you want. Whatsapp 97081 53000
3:32 3:57 aapne bina drag liye puri range kaise select ki?
@ExcelUniverse
Жыл бұрын
Cell Ko select karne ke bad Shift+Ctrl ko hold rakhna hai or arrow key press karna Hai
Sir I have a query , how can I send you that screen shot
@ExcelUniverse
3 жыл бұрын
97081 53000
@Viishhal.
3 жыл бұрын
@@ExcelUniverse thanks sir
@agsir
Жыл бұрын
8:33 फिक्स कैसे करेंगे?
@ExcelUniverse
Жыл бұрын
Use function key F4 to fix the range
@agsir
Жыл бұрын
I used it sir, but my sumproduct result different from rank result, only first 2 cell match only. अपनी परेशानी डिटेल के साथ भेजे हैं, वीडियो द्वारा सामाधान की प्रतिक्षा है।
way to complex, there is a simple way of doing this using countif function
@ExcelUniverse
3 ай бұрын
Yes that's also a very unique tricks