View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mile3024
 
Posts: n/a
Default Rank where lowest value is highest rank

I am having trouble ranking cells where the lowest value receives the highest
ranking. Excel RANK function always wants to reward the highest number with
the highest rank. What do I need to do to adjust this formula.