Excel - duplicate numbers being given different rankings

Have list of percentages which have been sourced from another sheet within an
excel document - when i rank these some duplicates are given the same ranking
and some are given different rankings eg. 2 results of 6.16% were both ranked
13 while 2 results of 6.11% were ranked 10 & 11

  Jacob Skaria replied to Mantis

Increase the number of decimals to see whether the cells contents are exactly
same or is rounded off and displayed as 6.11

--
Jacob

  Bernd P replied to Mantis

Hello,

I suggest to use Countif instead of Rank:
http://sulprobil.com/html/rank.html

Regards,
Bernd

is why I supppose I am here. :) I need a formula that will sort store rankings based on the highest average score and the highest plus "plus / minus score". Here is information: Column A3:A21 is the store numbers Cloumn X3:X21 is last week average (percentages) Column Y3:Y21 is this week average (percentages) Column Z3:Z21 is plus or minus vs last week average (percentages) Now in column C28, which is rank 1, I want the store number (A3:A21 to the top 5. Thanks for all that will help! Excel Miscellaneous Discussions Cloumn (1) Percentages (1) Rankings (1) Supppose (1) Week (1) I have figured out how to get the numbers to

Discussions PERCENTRANK (1) RANK (1) SUM (1) Report (1) Subscribers (1) Max (1) Xdemechanik (1) Percentages (1) Say we have this data in a column: 75 46 59 75 32 62 C1: = PERCENTRANK($A$1:$A$692, A1) Format C1 as percentage, copy down Returns relative rankings of the dollar amounts as percentages (0% - 100%, lowest - highest) for easier visuals. Spends of > = 80% will be your top 20%

Sorting percentages Excel I am trying to sort a spreadsheet where the values are percentages. I have the percentages set as a result of a formula from a different worksheet in the workbook. However help. Excel Miscellaneous Discussions Microsoft Excel (1) Worksheet (1) Workbook (1) LiengmeMicrosoft (1) Formulasbest (1) Percentages (1) Bliengme (1) Divides (1) Please give more details - formulas best wishes - - Bernard V Liengme 6.19% 3.47% 9920673 5.52% 4.31% 6.59% 2.71% keywords: Sorting, percentages description: I am trying to sort a spreadsheet where the values are percentages. I have the percentages set as a result of a formula from a different worksheet in t