Excel Magic Trick 1354: Rank with Criteria: Rank Football Teams by Total Wins & Division Wins
Vložit
- čas přidán 11. 07. 2024
- Download Files:
Start File and Finished File:
excelisfun.net/files/EMT1354....
Excel Magic Trick 1354: Rank with Criteria: Rank Football Teams by Total Wins & Division Wins
Download File: people.highline.edu/mgirvin/ex...
See how to use RANK.EQ and COUNTIFS functions to create formula to Rank with Two Criteria / Conditions to Rank Football Teams by Total Wins & Division Wins.
Every one of these videos is a winner. Very, very helpful.
omg, this is exactly what I was looking for. Found a really complicated formula on a reddit forum but this is the simple solution I was looking for.
All your videos are so good. Thank you. I love it when you double click to send the answer down and say in a surprised tone "...and...you gotta be kidding me..." - always makes me chuckle.
You are welcome! Glad the videos and informative and fun for you, Mike! Thanks for the support with your comment, Thumbs Ups and your Sub : )
Thank you, I have scoured the internet to do this (except I used a horse rating system for points then the lowest race times to separate those on equal points). Magic!
Great work, good for grading school activities. Learning something cool each day.
Glad the videos help! : )
Beautiful way to explain double link! Thanks,
Thanks. Just now learning the excel ">"& syntax was really helpful to me.
Glad it helps! : )
This was brilliant thank you
Exactly what I was looking for...thank you so much. Now, is there a way that I can have a third/fourth/fifth tie-breaker? For example, wins in conference, home wins, away wins, etc. added on for a further tie breaker to break the tie between St. Louis and Minnesota in your example?
Thank you ... This is helpful for me
Amazing videos, you are the most amazing excel coach ever. thank you!
You are welcome!!! I am glad that the videos and coaching help : ) Thank you for your support, LondonTownFC!!!
Thanks @@excelisfun We now use a final step with a vlook up to ensure that everyone time a team changes position in the table so they change accordingly. Thanks Again.
@@LondonTownFC Cool!!!!!
This was so helpful, thank youu!!
I have a question.
What if you have a tertiary criteria?
Thank you very much god bless
I really like what you are doing. Kudos for sharing your insights to the world of spreadsheet nerds...but am I missing something ? Is your sheet only valid for one week only ? If Philadelphia loses to Green Bay (heh, not likely) this Sunday will they not fall from the number one seed or at least potentially do so ? I swear to you, im not trying to be a jerk. I want you to succeed as I am working on a sheet that does the same thing (as your's ) for both AFC/NFC conferences and it is a daunting task. My main problem right now is finding an Excel command that will automatically swap teams (rows) when they fall from or ascend to the a different seed. You have already given me some great ideas. Keep up the good work and don't hate me because im an Astros Fan. Your Phillies had me so worried after game 3. Hats off to Bryce Harper, Kyle Schwarber and the rest of your scrappy Philadelphia Pennant Winning Season :-). You should be so proud.
When you typed in "Rankif" I almost dropped my coffee! ...Good solution. Thanks Mike!
I love that!!! : ) I watch Excel videos in the morning too, and I have definitely almost dropped my coffee a few times over the years! You are welcome as always, Online Excel Teammate Kevin!
I have the same question as KED2313. How can you add a 3rd condition to further break the tie between STL & MIN or TB & CAR?
Great as Always.
Glad you like it!
It is really great video, thank you : )
You are welcome!
Very clever! Is there a way to do this without skipping a natural number sequence? (1, 2, 3, 4, 5, 6, 7, etc.)
Great video. Thanks
You are welcome!
Could you help me please?
This situation happens very often, what if you need in league table to rank by points, and points can be equal for two or more teams, and that case you should rank by games playing with each other. I cannot find normal formulas for solving that problem. Please help me. Thanks!
Smart COUNTIFS! :)
: )
Can you please help me in rank formula if E12 and E13 is getting same value i.e 9 and 9 so how could we change E12 and E13 into 9 and 10 with if condition.
Nice bro
I need some help and was wondering if you could help me with my spreadsheet
Thanks
Hi Sir! I just wanted to ask if how are you going to rank between 2 the same scores but they had to be on the same rank and then followed by the next number of rankings? Eg. two items with the same score of 20, they have to be both rank 1, then next has a score of 18, then it should be ranked 2nd. Thanks for your help and stay safe!
Have you resolved this?
@@ayodejiajilore7351 czcams.com/video/_r8G6lcJ2TI/video.html
Thank you mike , these solutions goes only when data is sorted ?
No. It will work no matter how the data is sorted. I definitely should have showed how sorting does not affect formula... : (
ExcelIsFun No problem Mike you are always briliant
Hi, not related to that course but do you have any video that show how to extract data from a products catalogue on sheet 1 to an invoice on sheet 2? Select quantity directly on the catalogue it will automatically transfer to invoice? Thank you so much !!!
Maybe VLOOKUP? I have many videos on VLOOKUP, here is one, maybe:
Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice
czcams.com/video/l0Ivhe22cvM/video.html
or
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
czcams.com/video/iJ1MO2xx8wQ/video.html
Thank you very much !
learnt something new
Cool! New thing learned is cool : )
Splendid
Glad you like it! : ) Thank you for your continued support!
Great as always!!!
Can i propose another one?.... Rank without RANK :-)
=MATCH(B4+C4/100,LARGE($B$4:$B$19+$C$4:$C$19/100,ROW($B$4:$B$19)-ROW($B$4)+1),0)
Bill when I copy you formula I get an #N/A
@Manesh Zaweri , sorry.... i forgot to mention...this is CSE formula (CTRL+SHIFT+ENTER
That is sooooooo rad!! Bill Szysz!! I think it is very rank-less, though : )
Say your raw data (Wins, Div Wins) is not sorted. How would you sort it dynamically with a formula. I have a spreadsheet that is similar, but replace Wins with Pace and Div Wins with Month. I need to sort the fastest pace for miles ran within a month. My raw data is entered on a separate sheet in chronological order entered for each day regardless if a run was done on that day and on another sheet I pulled just the days where a run is recorded with the miles ran, and pace. This other sheet is still in chronological order, but I need to sort the Pace column by the fastest pace within a single month.I used EMT 707 to rank them within each month, but am lost on how to dynamically do the sort as listed above.
has anyone a decent fixtures list creator tutorial?
سلام خدمت همه شما من سوال داشتم که چگونه اتوماتیک سورت کنیم داده
OH MY GOD
Thanks Mike. Surely fake wins and losses because Eagles no way near 11 wins this year... LOL.
You are welcome, WRH!!! Yes, someone sent this to me, and then I changed it a bit to created a bunch of ties...
E4=SUMPRODUCT(($D$4:$D$19=$D4)*($B$4:$B$19=$B4)*($C$4:$C$19>$C4)), must insert column "Rank official" - F4= SUM(D4:E4)