View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MichaelZ MichaelZ is offline
external usenet poster
 
Posts: 19
Default Need to rank values with ties

Could someone provide a duplicate ranks with decimal fractions algorithm. I
need to rank data that has tied values, but I want a ranking that is unique
for each value, so I need to rank the data using decimals, (eg., 1, 2, 3.1,
3.2, 4, etc.).
Thanks in advance