View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default Rank - Change the Rank of a Tie

+Hi- I have set up a rank using a standard ranking formula. I have a total
of 156 items that I am ranking. The values of the rank range from -660 to
756. Most of the values are zero and tie at a rank of 43. The next lowest
rank after all of the 43s is 155. I would like for the rank of the 43s to be
154, not 43. Can I do that with a formula?