RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel

RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel

Download the Assignment Master Practice Folder here (All Playlist Examples at one place)

===========VIDEO COURSE============================
✅ Mastering Excel Video Course
✅ Mastering Power BI Video Course
✅ Mastering VBA Video Course
✅ Mastering SQL Video Course
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
====================================================
Videos in a Sequence -Basic to Advanced EXCEL

Value add-ons Playlist

Let's Connect:

#rankfunction#excelranking#Innozant #sumproductformula#rankiffunctionexcel

[satishojha]

Thanku very much sir aapka bhi naya saal tarkki bhara ho aur youtube par excel search karney par sabse phele aapka video miley 🙏🙏🙏. Good night sir 😇😇

[tejpalsain]

Thanks sir for Rank function in new style.
आपके और आपके परिवार को को नववर्ष की हार्दिक बधाई हो। आप हमेशा ऐसे ही मुस्कराते हुए सफलता के शिकर को छुए। ओर हमें भी प्रेरित करते रहे हैं, और हम आप से ऐसे ही आनन्दपूर्वक सीखते रहें।
Happy new year.🌹🎈🎈🎈🎈🌹

[pawanverma]

Wishing you a blissful new year. Hope that joy and success follow you in every sector of life.

[pramodbhavsar]

Wish you Happy New year and God bless you for good health because helth is wealth. rankif function is creat by you with sumproduct with simple example yesterday I award with scientists you prove in New year thank you very much sir

[kunalkedar]

Very useful formulas for education dept. Thank you sir

[adazaad]

Bahut achha sikhne ko mila sir very good and happy new year 2021

[situsahoo]

Amusing.and most helpful .sach bole ek dum dil khus kar diye.sir.

This one is not last video 2020.

Best Of Best.❤️❤️🎉🎉

[Rajeevkumar-ruyv]

Hi sir, kindly explain why you used double negative sign in right function in supriya's question.while not used same sign in left function

[ramverma]

Hi....What if 2 conditions to be giving error message while applying 2nd condition

[gumnaam]

In Case study solution, why the need to use coerce in case of RIGHT func part and not in LEFT func part?

[examcell]

i need to rank the data including suffixes also, like 1 as 1st, 2 as 2nd, 3 as 3rd so on, please mention the formula

[Jitenderkumar-yprn]

Best video with powerful formula.... ty sir ji & Happy New year 2021....😍❤❤

[shubhsadaphal]

Sir amountwise postion of branches but rank 2 and 3, 6, 7, 9, 1012, 13, and 15 missing

[mohammadaamirkhan]

A Big Thank you for making a good video.

[Gulabi_Nagariya]

How can i define the name of the rank. For example if i choose between 100 people for ranking that who is on 1-2-3 and other after that i want the name of the person on the rank

[hsgusain]

Thanks sir... Same I have used while ranking to region wise and PAN India

[pramodbhatt]

Hello Sir, In case there is duplicate values in Finance department What to do??. I'm trying the same but it is showing same rank in both cells.

[Rk-bhru]

it skips some number how fix it sir. help me.

[balamira]

Sir why there is no coerce in the first 2 criteria? Date and left? Any reason?

[rajeshakkineni]

Aap kaise formula check kiyaa.. cell mey.. shortcut key kya hey ji.... Thoda batavo