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.

      solution1.JPG

       

      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

       

      solution2.JPG

       

      First ranks should be:

      Technology 1

      Office Supplies 2

      Furniture 3