View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Karl
 
Posts: n/a
Default Is there a better way of doing this?

Ryan,
That works except for the last two columns. In the last two
columns, the lower the value the better.
I tried "reversing" your formula like this:

=INDEX({"A+","A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F"},MATCH(J2,PERCENTILE(J2:J29,{0,0.05,0.1,0.15 ,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55,0.6,0.75}),1) )

and that seems to do the trick.

Thanks for you help!

Karl