Quote Originally Posted by darkyam
If the original values are in A1:A13 and the ranked values you showed are in B1:B13, add +(COUNTIF(A$1:A$13,A1)-1)/2 to the end of the ranking formula in B1 and drag down.
Thanks. This helped but I still needed to do some rigging because column had has a variable amount of entries and the columns that don't have anything show a 0. Therefore the COUNTIF statement is counting too many cells as having data. So I had to change that statement to reflect the difference.