— CAN YOU SOLVE THIS - EXCEL CHALLENGE 132 —
(Solutions in any language are also welcome for Excel Challenges)
List the Top 3 players whose rank improved the most from 2021 to 2022.
Rafael Nadal’s 2021 rank was 5 and 2022 rank was 1. Hence, he improved by 4.
Taylor Fritz’s 2021 rank was 8 and 2022 rank was 16. Hence, he didn’t improve as his rank fell down. In other words, he improved by -8.
If either column B or C is empty, then that row has to be discarded.
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/duPXf45q
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post