Hello,
I have a list of results that I want to rank using the RANK function. In situations where the results table contains the same values, the RANK function displays the resulting ranking for each record in the table which when multuple results have the same value, causes the same rank for each respective value is displayed (e.g. 1,2,3,4,4,4,7,8,9,9,9,9,13). Is there a way to modify the formula so that when multiple result values in the table are the same, the formula returns the appropriate rank for only the first value and then return a blank for the remainder of the results values that are the same? I have attached a sample file that includes the results table and the rank formula. The file also demonstrates how I would like to see the results of the rank formula displayed.
All thoughts and suggestions will be appreciated.
Bookmarks