August 21, 2019
Is there a simple power query UI way to achieve ranking multiple cols ?
Rather then the rather complex M code https://www.excelforum.com/exc.....lumns.html
July 16, 2010
November 8, 2013
There is no UI ranking, but you can try this:
Sort 2017 column Descending, then add an index column, this index will be your 2017 ranking. Do the same for 2018 and 2019.
You can try other methods from here: https://www.excelguru.ca/blog/.....wer-query/