PDA

View Full Version : Rankx challenge



Spencer_2
2017-02-16, 03:12 AM
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

Paul_Christie
2017-02-16, 09:41 AM
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

Spencer_2
2017-02-16, 01:26 PM
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