RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel
RANKIF Function | Ranking with Condition using SUMPRODUCT| Customized Rank in Excel
Excel Array & Sumproduct Playlist Link- • Excel Array & Sumprodu...
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#rankfunction#excelranking#Innozant #sumproductformula#rankiffunctionexcel
Пікірлер: 107
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 😇😇
@Innozant
3 жыл бұрын
Thanks Satish Ji itne valuable aur pyare wish ke liye ...happy new year ❤️🙏
very nice illustration,
Very helpful, thanks
useful knowledge. loved it
@Innozant
3 жыл бұрын
Thanks dear.happy new year ♥️🙏
very nice sir...rankif is super.
A Big Thank you for making a good video.
@Innozant
2 жыл бұрын
Thanks Aamir
Excellent Sir🎉
@Innozant
Жыл бұрын
Thanks
Very useful formulas for education dept. Thank you sir
@Innozant
2 жыл бұрын
Thanks Kunal Ji
Excellent logic sir, Keep shining
Thanks sir... Same I have used while ranking to region wise and PAN India
@Innozant
3 жыл бұрын
Thats good dear.🙏❤️
Bahut achha sikhne ko mila sir very good and happy new year 2021
@Innozant
3 жыл бұрын
Thanks Azaad🙏♥️happy new year
Amazing, Very Nice Sir
@Innozant
3 жыл бұрын
Thanks Amit Ji
Amusing.and most helpful .sach bole ek dum dil khus kar diye.sir. This one is not last video 2020. Best Of Best.❤️❤️🎉🎉
@Innozant
3 жыл бұрын
Thanks Situ Sahoo Ji.. thanks dear Happy new year ❤️🙏
Thanks sir for Rank function in new style. आपके और आपके परिवार को को नववर्ष की हार्दिक बधाई हो। आप हमेशा ऐसे ही मुस्कराते हुए सफलता के शिकर को छुए। ओर हमें भी प्रेरित करते रहे हैं, और हम आप से ऐसे ही आनन्दपूर्वक सीखते रहें। Happy new year.🌹🎈🎈🎈🎈🌹
@Innozant
3 жыл бұрын
Happy New Year Tejpal Ji❤️🙏
Best video with powerful formula.... ty sir ji & Happy New year 2021....😍❤❤
@Innozant
3 жыл бұрын
Thanks Jeetu .. happy new year ♥️🙏
Wishing you a blissful new year. Hope that joy and success follow you in every sector of life.
@Innozant
3 жыл бұрын
Thanks Pawan..Happy New Year dear♥️🙏
Very nice.
@Innozant
2 жыл бұрын
Thanks dear
Excellent
@Innozant
3 жыл бұрын
Thanks Mahaboob.🙏❤️
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
@Innozant
3 жыл бұрын
Thanks Pramod Ji,Happy New Year to you and your family🙏♥️
Happy New year2021 👍🙏 Good Sir.
@Innozant
3 жыл бұрын
Happy New Year Rahul🙏🙂♥️
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.
happy new year ,sir g 🙏
@Innozant
3 жыл бұрын
Happy New Year ❤️ Ishu..tc.gn
Happy new year 2021 sir 🙏
@Innozant
3 жыл бұрын
Happy New year Puran
Happy new year sir
@Innozant
3 жыл бұрын
Happy New year to you and your family
Thnq sir 💐
@Innozant
3 жыл бұрын
Thanks dear . happy new year ♥️
@gauravbhatia7987
3 жыл бұрын
@@Innozant happy new year dear sir
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
@Innozant
2 жыл бұрын
Hi Rejeev ,No need to pass -- in left Function as reference is value e.g 76 but in Right Function Reference is Text eg CSE and Right is a text function that's why we need to pass double negative to coerce true vale into 1 and false into 0. Hope you understand. Kindly evaluate your right formula without and with passing -- using F9
Dear Sir Wish you and your family a very happy and prosperous new year. Thanks Jayanta Bhattacharyya
@Innozant
3 жыл бұрын
Happy New Year Jayanta to you and your family 🙏♥️
Want criteria waise rank if score repeat in same criteria without skipping rank
How can can calculate Position up to 100 students with sign(st,nd,rd,th). just like 1st,2nd,3rd,4th etc. Thanks, your way of teaching is very polite and i like it.
👌💐
@Innozant
Жыл бұрын
Thanks Aaradhana..Happy learning ❤️
Sir hum to fresher hai.. Or bht se student bhii fresher hii honge.. To plzz sir ek play list... Real office work bhii bana lijiye.. Jisse hume experience bhii milega.. Or samjh me bhii ayega k office work kese hota hai..
New formula by innozant sir
@Innozant
3 жыл бұрын
Thanks Sonal ..happy new year 🙏♥️
Hi....What if 2 conditions to be applied........its giving error message while applying 2nd condition
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
Grand entry and u made everyone understand about sumproduct(rankif....continue we r learning ...thank u so so much... i hope ur channel will grow... alwys dua......
@Innozant
3 жыл бұрын
Thanks Sajjad for best wishes ❤️🙏 Happy new year
Aap kaise formula check kiyaa.. cell mey.. shortcut key kya hey ji.... Thoda batavo
@Innozant
2 жыл бұрын
Evaluate kiya hoga.slect krke F9 ydi kisi argument ke inside evaluate Krna hai to ya step by step check Krna hai to Alt+T+U+F
it skips some number how fix it sir. help me.
In Case study solution, why the need to use coerce in case of RIGHT func part and not in LEFT func part?
@Innozant
Жыл бұрын
Kindly evaluate right function ,it will show you what ..text na but we need no. Onlye that's why use -- to convert text to number
@gumnaam6068
Жыл бұрын
@@Innozant Yes Sir, i figured that part out later on.. Thanks for the help 🙏 Aap Jha Sir ho na? If yes, I'd like to express my heartfelt gratitude for the immense amount of help your tutorials have been for us learners.. u have been a godsend for us 🙏🙏 just a humble request, pls provide VBA tutorials ASAP 🙏 thanx in advance
@Innozant
Жыл бұрын
@@gumnaam6068 Thanks dear.God Bless you
sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable
Pls complete array & lookup function then start on power pivot
@Innozant
3 жыл бұрын
👍👍♥️♥️
सर rank if me, sumproduct formula उपयोग में लेने पर समान नंबर के लिए एक ही रैंक आ रही है, अलग अलग रैंक कैसे शो होगी । example - 50, 50 मार्क्स के लिए 10 ,10 रैंक शो हो रही है , 10,11 रैंक शो कैसे करे
Sir g2
Sir why there is no coerce in the first 2 criteria? Date and left? Any reason?
@Innozant
2 жыл бұрын
Dear Mira , Already explain you that with we use * or corece to convert trur and false into 1s and zeroes
Nic one sir, & wish u happy happy new year sir Sir new year gift ch #jatadharri ji chahide ne Plzz😂
@Innozant
3 жыл бұрын
Thanks Raman.., happy new year ♥️🙏 Jatadhari Ji pasand as gye aapko 😀
Wish you a very happy new year sir... Ek baat aur hai sir mere wife ko jaise TV serial dekhne ki aadat hai waise hi mai aaj kal 8 bje apke video ko dekhne aa jata hu😂 apki wajah se daily KZread check karne ki adat pad gyi h... Pahle mai questions dekh ke kaun sa formula use hoga ya kaise start krna hai nhi samjh pata tha but apki video ko dekhne k baad bohat hadd tak samjh aa jata hai ki kaun kaun sa formula apply hoga.. problem ko dekhne ka apne naya azariya diya hai.. 2020 me agar maine kuch bohat achha kaam kiya hai to wo apke channel ko join karke.
@Innozant
3 жыл бұрын
Happy Ne year Rakesh Ji🙏❤️ Thanks dear ,lagatar practice krte rhenge to aapko khudme Acha lgega Kuch waqt baad , learning kbhi mat chorna .m really happy to listen this wonderful words from you ,👍🙏♥️
Sir kya aapka no mil skta h, aapk liy ek Questions hai , jo aapne Esme nhi batay
@Innozant
2 жыл бұрын
@innozantofficial telegram id
sir jab sumproduct lagaya apne to department is less than group of department cells q liya apne ,
@Innozant
3 жыл бұрын
phirse video dekhiye Maine explain Kiya hai dear ki kyu liya Maine
8:10
@Innozant
2 жыл бұрын
??
Sir sumproduct ki vidio serial by upload kro as crack job #1 2 3....
@Innozant
3 жыл бұрын
Raju ji Array and sumproduct series in sequence hi upload hain..seprate playlist hai bna hua uska ..plz check and learn from there
Sir ap jo bhi function sikhate hai acche se samjh me aa jaata hai.. Lekin jab real office work dekhta hu paseena ane lagta hai😀.. Jese aaj apne supriya dixit kii file di thi use dekhte hii samjh me nahii aya kese hoga.. Iska matlab real office work alag hota hai.. 😢
@Innozant
Ай бұрын
👍Keep Growing
I want to give ranking only between 1 to 5
@Innozant
3 жыл бұрын
Use rank as per your requirement
@bikassingh7469
3 жыл бұрын
@@Innozant there are 10 differet values in the rows and I want to do scoring from 1 to 5. How do I do this on excel
रैंक फार्मूला के लिए जो स्टूडेंट पास है उसका ही रेंट निकालना है। और समान मार्क्स वाले स्टूडेंट का रैंक इक्वल आता है । इस प्रॉब्लम को कैसे सॉल्व करें
SIR MAINE YE USE KIYA OR OUTPUT BHI SAME AAYA H =SUMPRODUCT(($A16='Closing Price'!$B$2:$B$3473)*(B$15='Closing Price'!$D$2:$D$3473&" "&'Closing Price'!$E$2:$E$3473)*'Closing Price'!$I$2:$I$3473) Thankyou sir
Sir ek questions kr dijiye maan jaonga aapko...plz sir. Question hai 1 workboook me 4 sheet hai.. Sheet 1 me 1to 10 tk number hai Sheet 2 me 1to 25 tk number hai... Sheet 3 me 1 to 30 tk number diye hue hai..sb no A2 se start hai.. Aapko sheet 4 me ek formule se ..tino sheet ka data ek columns me leke aana ha... Yaad rahe formula dynamic hona chahiye...means kisi me sheet me number kamm ya jyada krne pr hm sheet 4 me ussi formula bina change kiye hue.. drag kr sahi kr sake...ok sir...plz help sir
@yogendersingh8464
Жыл бұрын
Plz help 🙏
Sir 312 less than hai to true hona chahiye... False kyo aa raha hai
@Innozant
2 жыл бұрын
Koi cell freeze nhi kiyabhoga dear..may be ..ek baar recheck kriye.
@paramjeet975singh3
2 жыл бұрын
@@Innozant ok sir check karta hu
why we are using -- only with right() not with left, Why =SUMPRODUCT(--('Closing Price'!$B$2:$B$3473=Strategy!$A16),--('Closing Price'!$D$2:$D$3473=LEFT(B$15,2)),--('Closing Price'!$E$2:$E$3473=RIGHT(B$15,4)),'Closing Price'!$I$2:$I$3473) this is not working.
(1) =SUMPRODUCT(('Closing Price'!$B$2:$B$3473=$A16)*(LEFT(B$15,2)='Closing Price'!$D$2:$D$3473)*(--RIGHT(B$15,4)='Closing Price'!$E$2:$E$3473)*('Closing Price'!$K$2:$K$3473)) Sir mujhe ye samajh nahi aya ke (1) function me (--) just "RIGHT()" function se pahle kyu lagaya?? jabki hum normal condition me "--(RIGHT(B$15,4)='Closing Price'!$E$2:$E$3473)" ese krte hen... Just like... (2) =SUMPRODUCT(--(RIGHT(G24,2)=$E$26:$E$29)) is function me humne just before RIGHT() se pahle (--) nahi lagaya .... or agar lagayenge to output galat ayega Please give some clarification
@Innozant
3 жыл бұрын
sumproduct ke Ander parenthis ke inside hum criteria lete hain na to evaluate? to right se pehl3 hi coerce karayenge na