7 Replies Latest reply on Oct 17, 2013 5:28 AM by Kyle Pipkins

    Comparative Rankings across years

    Mike Wilson

      I have a simple worksheet which lists total sales by brand for year 1 and year 2.  I have ranked year 1 using the Index() function and wish to compare the year 1 ranking with the ranking for the same brand in year 2. I would appreciate some advice as to how I can do this.