— CAN YOU SOLVE THIS - EXCEL CHALLENGE 77 —
(Power Query solutions also welcome for Excel Challenges)
— This week will be FIFA World Cup week. All challenges will be related to FIFA World Cup only for this week. —
Given are ELO ranking for Nov-21 and Nov-22 for FIFA teams.
Find the countries which had the best and worst improvement in rankings. Morocco improved by 24 ranks which was the best and Belgium and Ecuador had worst improvement by -5 ranks.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dDBhnR-7
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365
Excel BI’s LinkedIn Post