Hello everyone, I found this forum using a search engine and I am amazed by how full of information it is, I looked through it for about an hour finding a lot of great information however I couldn't find exactly what I'm looking for and maybe that is because I don't know what it is called.

I have an old excel sheet that provides a combined ranking of items for different items and sets them into a 1-12 order, I do not have the original sheet for it though so the formulas are not available to me. I was wondering if anyone would be able to help with that from here. Also, with the ability to provide some slight edits to the formats.

Below is what the copy-paste of the format looks like.

Column 1 is simply product numbers, while daily/monthly are their percentages and change daily(these seem to be the only editable items on the worksheet, as variables). The "rank 1-12" is determined from highest to lowest percentile then it auto ranks them that way with all rankings over 20% being green, from 20-18% being yellow, and below 18% it is red. It then gives a total power ranking (daily + monthly) with a total number of points followed by item ranks from 1-12; with total rankings being 1-4 green, 5-8 yellow, and 9-12 red.

Is anyone either able to help me recreate this excel sheet or provide any assistance. Thank you very much in advance.


Daily Monthly POWER RANK
RNK Rank TTL PTS RANK
134 8.56 12 8.56 12 24 12
135 18.45 8 18.45 8 16 8
138 19.88 7 19.88 7 14 7
142 17.89 10 17.89 10 20 10
144 21.26 6 21.26 6 12 6
499 9.77 11 9.77 11 22 11
797 22.63 5 22.63 5 10 5
884 28.3 1 28.3 1 2 1
1019 25.37 3 25.37 3 6 3
1046 26.36 2 26.36 2 4 2
1061 18.18 9 18.18 9 18 9
1128 23.26 4 23.26 4 8 4
Total 18.54% 18.54%