Rankx challenge

Spencer_2

New member
Joined
Nov 29, 2016
Messages
13
Reaction score
0
Points
0
Have gone through multiple iterations of the RANKX function... Some are returning a value but not in the way I need.
I have created several calculate formulas that show share of column total and % Change for a specific item withing a column.
What is the best way to show that items rank against other items for a summary? Not sure how to achieve this.

Attached is a file showing column headings and sample data.

Thanks, as usual, for all the help.

Spencer
 

Attachments

  • example.xlsx
    9.2 KB · Views: 11
Rank comes in two flavours RANK.EQ and RANK.AVG. I've added two columns on to your example the first colum use .EQ and the second column uses .AVG so you can see the difference.

Paul
 

Attachments

  • Copy of example-1.xlsx
    9.8 KB · Views: 14
Thanks Paul... Will take a close look. Will upload later today a more complete spreadsheet. Not sure my spreadsheet really posed the question correctly.

Best, Spencer
 
Back
Top