Hi!
I am playing with the RANKX function.
I am able to display the bottom 5 of the current year by Region (X and Y) and by Workshop (AAA, BBB...).
The ranking at the region level is different than at the workshop level. I want to see the year before to compare with this year result. The problem is that I get all of last year workshop but I only want the bottom 5 (see big arrows) of the current year.
Link to workbook in Google Drive
Thanks for your help!!!
I am playing with the RANKX function.
I am able to display the bottom 5 of the current year by Region (X and Y) and by Workshop (AAA, BBB...).
The ranking at the region level is different than at the workshop level. I want to see the year before to compare with this year result. The problem is that I get all of last year workshop but I only want the bottom 5 (see big arrows) of the current year.
Link to workbook in Google Drive
Thanks for your help!!!
