Forum Discussion

AVP68's avatar
AVP68
Copper Contributor
May 12, 2019

Overall/Final Rank from multiple ranked lists

Lets say I have from 25 sources of the same lists of data of items that have been ranked.  The data list has 5 items ranked from position 1 (best) to position 5 (worst). How do I create an overall r...
Formulas and Functions
  • AVP68's avatar
    AVP68
    Copper Contributor
    May 14, 2019

    TwifooYes, thanks for the file as I was thinking along the same line and it works. The RANK on the total SUM gets me the same result if applied on MEDIAN or AVERAGE in lieu of the SUM.

     

    Thanks.

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 14, 2019
      You’re welcome.
      • AVP68's avatar
        AVP68
        Copper Contributor
        May 17, 2019

        Twifoo  Further to this, I have a final step here on the next tab sheet I just want to show the item, rank, and average summaries in ascending order by item. So what I am trying to do is on the Summary tab is have a formula in column A that will lookup the Data tab in ranked column B  and populate the Summary tab in ascending order. Likewise similar formula in column B & C.  Will this be a Index/Match with Indirect or similar?

         

        See attached modified file.

         

        Thanks,

        Jay

Resources