Rank by multiple criteria in Excel

Подписаться 542

Просмотров 25 тыс.

50% 1

Hey guys! Ever had to do ranking by multiple conditions while working on a report or dashboard. Here's my take on Ranking by multiple criteria in Excel.
#nazyam #nazyamm #practicemakespermanent #vlookup #2021 #rangematch #match #index #hlookup #msexcel #powerpoint #screenrecorder #Video.Guru #formula #msexcel #excel #Excel2016 #ExcelBeginner #ExcelBasics #ExcelEssentials #LearnExcel #microsoftexcel #microsoftexceltraining #office #microsoft #education #business #onlinecourse #office365 #microsoftoffice #microsoft365 #tipsexcel #tutorialexcel #xelplus #worksmarternotharder #AUS #wwwausedu #BecauseTomorrowMatters #Proud_AUSer #worthit #UAE #Pakistan #powertobeyou #rank #multiplecriteria

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@viditvarshney2167 4 дня назад

Countifs will FAIL when you have duplicate sales in a same dept. Example: Dept1 || 5 || Dept1 || 7 || Dept1 || 5 ||

@vivekmusafir4492 7 месяцев назад

Fantastic tutorial…thank you…however I have a query, example two guys end up having same ranking? It may happen…in that situation I want excel to evaluate other parameter associated with candidate/employee… example two employees having same rank…but employee A is relatively new in organisation but employee B is quiet old and experienced…I want to give advantage to new employee…we can have another column capturing tenure in days for each employee…hope I am able to convey my query…please help.

@umarvlog102 2 года назад

Keep it up

@NazyaM 2 года назад

Thank you

@farooqm2820 9 дней назад

Great. Thanks. Any formula to now show these in ranks in next page/ as report, by department wise. i.e. I need to show who is 1st, 2nd, 3rd in Dept 1, etc..

@trendingtube5741 Месяц назад

Hi , I am suppose to rank my work shifts , what I would like to fill out 20 shifts of my choice and then auto rank the rest without affecting my personal preference, pls guide me in how that can be done

@yerraguntalacharanchowdary6099 5 дней назад

Thanks madam this vedio helps me in my task.

@hussainahammed9227 3 месяца назад

Thank you so much for sharing. It's an excellent way. You are beautiful!

@sravanlittleangelshighscho2902 5 месяцев назад

ok... but same sales repeated values no change rank, plz explain to change..

@Adriaan.J.L 5 месяцев назад

Are you Turkish? Just wondering, because you sound Turkish though :)

@NazyaM 4 месяца назад

Thanks for the compliment. I'm from Dubai but my nationality is Pakistani.

@sumitbhowmick2540 Год назад

Can you please determine the rank with repeated values in the same group ranking?

@usmanzafar7950 Год назад

we should pray to God that we must never come across with same values otherwise we have to pay for it ....i do not like these formulas at all ...the second formula gives different ranks to the same values which is totally wrong ...result ...the best i think the result that i want is that it should not give different ranks to the same values rather it should give the same ranks and the next number should not missing at all ...for example if first two values are same and the third one is different it should give same rank that is one to the same values and the third rank should not be three it should be two ...that is what i need if you know any formulas then let me know

@FBDISTRIBUTORSGROUP 2 месяца назад

thank you very much it's perfect

@hafizuddin9507 9 месяцев назад

madam! I m ur big fn, Plz help me, about RANK If i have two or more ranges, mark, grade to rank, For example, Masud: grade-5, mark-80 Rana: grade-5, mark-88 Robi: grade-5, mark-70 Lina: grade-4.90, mark- 90 I want, it 1st rank by grade, if there same grade got more then 1 student, that case it will rank by mark... How to do it madam, plz help

@NazyaM 9 месяцев назад

Hi thank you for the support. I was testing out your example. Kindly let me know, in your example, you want total ranks unique for each individual. For instance, say I change grade of Robi to 4.5, then based on rank on grade - 1 will be Lina, rank 2 will be Robi; and with same grades, rank will be done on marks - so Rana is getting 1 and Masud rank 2. Is this the result you want (I have worked out this solution)? Or you want (like the example I gave here) that after ranks are gives to those with unique grades, then rank on marks should start with 3 then 4,etc?

@hafizuddin9507 9 месяцев назад

@@NazyaM thank you madam for replying me. I want Rana will be 1st Masud 2nd Lina 3rd Robi 4th if grade decreased to 4.5 Rank will not be repeated...

@NazyaM 9 месяцев назад

Hi, I have posted the solution in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Bg2rS3fgGUw.html . Hope this solution helps. Good luck and God bless.

@PavanKalyan-ys4zp Год назад

how to find highest multiple of 2 from a column(having numbers) ?

@Rk-bh7ru 5 месяцев назад

it skips some number. how fix it.

@jamesrprince 11 месяцев назад

Great stuff. Really helpful.

@NazyaM 11 месяцев назад

Thank you so much 🙂

@mrsarthakkhattar 5 месяцев назад

Hey Nazya, thank you for this tutorial, but I think this method will not work if we have repeating values in the dataset

@NazyaM 5 месяцев назад

Hi thank you for going through my tutorial. I am working on solution for handling duplicate results. Stay tuned, I hope it might be useful.

@viditvarshney2167 4 дня назад

@@NazyaM Did you got any work around ?

@ravigadani 7 месяцев назад

addresses a specific need. Thank you.

@pruthviraj9917 Год назад

How to avoid repetitive ranking?

@menime3933 Год назад

Is there a way to rank a 2 phase result? So let's say in Phase 1 you did not qualify to move to Phase 2, you will rank lower. So if Phase 2 Qualifiers ranked 1-9, then those who were "stuck" at Phase 1, will then rank 10-12. In a scenario where there are 12 participants

@NazyaM Год назад

Interesting scenario, let me test it out and get back to you. Are there fixed positions in phase 2 (1 till 9) or depends on qualification criteria of phase 2?

@NazyaM 9 месяцев назад

Hi. A similar type question was raised someone else. I have posted solution in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Bg2rS3fgGUw.html . Kindly have a look if this helps answer your question. Do let me know, if it doesn't help, I'll try finding solution to your scenario.

@mohit7988 Год назад

If the sales is 0 for 3-4 city it will show repeated rank , how make it unique ranking using this formula

@NazyaM Год назад

Hi Mohit. To understand your question better, are the cities same where sales are zero?

@SundayRockersOfficial Год назад

What i understand is , there are different cities containing sales value "0" for two three entries , is it ? No point of ranking them then

@dolittlediehard1670 Год назад

Nice, like it but i was looking to rank on multiple columns at the same time. So we rank by column 1 first but then we rank in column1 by the values in column 2 if the values in column 1 are equal. And extend this to 3 columns?

@NazyaM Год назад

Hi there. Can you walk me through the example you have at hand? For column 1, what's the condition you looking at, what's in column 2, and what's in column 3?

@dolittlediehard1670 Год назад

The example i was thinking of was the English Championship. Places are decided by the team that has the highest number of points. But in the event of a tie is then decided on the goal difference. The team with the biggest goal difference wins if tied on points scored. A third column could be decided on 'fair play' points awarded. I don't believe fair play points are used but they could be.

@dolittlediehard1670 Год назад

Or how about this: Alarm medical sell medical equipment to hospitals. Sales staff are ranked on their sales as follow: whoever sells the most number of mri scanners is the winner and gets promoted. In the event of a tie then whoever sells the most number of bone density scanners is the winner and gets promoted however if this is tied then they are ranked on the number of x-ray machines sold. Mri scanners have the biggest profit, bone density scanners have the next highest profit margin and x-ray machines have the lowest profit margin.