Forum Discussion

llealsantos's avatar
llealsantos
Frequent Visitor
2 years ago
Solved

Rank function on selected dates

We need to apply conditional formatting to identify the top 5 and bottom 3 values in a dataset, based on user-selected fiscal periods. The selection can include non-continuous fiscal periods, and the...
  • Anonymous's avatar
    Anonymous
    2 years ago

    please check the rankx function what I have used on the dataset.


    Please check the final output.

    If you think that this helps you then accept this as your solution.