Ok, So I have 2 formulas that I am using. 1 is to assign a score based on weighted averages. The other one is used to place those weighted scores in 1 of 3 buckets. When I try to sort the Rank column or the Rank % Column by ascending or Descending, it doesn't place them in the right order. Refer to the example pic.
Formula in Rank column
Formula in Rank % Column=RANK(J5,$J$5:$J$32)+COUNTIF($J$5:J5,J5)-1
The Rank column is J and the Rank % column is K=(IF(K5<=(COUNT($K$5:$K$163)*0.35),"Top 35%",(IF(K5<=(COUNT($K$5:$K$163)*0.65),"Middle 35%","Bottom 30%"))))
Bookmarks