1 2 Previous Next 21 Replies Latest reply on Jul 25, 2019 9:41 AM by Hari Ankem

    Showing top n people with highest category A and their lowest category in one sheet

    Jiaqi Zhang

      I want to show the top n(5/10) people with highest category (lets say A) and also show their lowest and lowest only (but not 0) category amount as well. And this should be filtered by category name.


      I attached a dummy workbook where i got the highest category shown and i also know how to use index to show the top (5/10). But my problem is i cant get the lowest category to up as well.



        1 2 Previous Next