1 2 Previous Next 17 Replies Latest reply on Jun 26, 2019 11:29 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.

       

      Thanks!

        1 2 Previous Next