5 Replies Latest reply on Oct 30, 2015 6:08 AM by Toni Jormalainen

    How to calculate different level ranks?

    Toni Jormalainen

      I'm trying to use ranks in my charts but I'm having some problems... I found this thread very useful Ranking -  Rody's workbook has helped me a lot.


      As attached workbook shows I have managed to calculate ranks in Solution1 worksheet.



      In Solution2 I'd like to see first ranks as per category (as the same as in solution1), second rank as per sub-category. I have no idea why I added index there, maybe I thought it might help




      First ranks should be:

      Technology 1

      Office Supplies 2

      Furniture 3