In the cells F4:K4 I have 6 values that are formulated from elsewhere in my workbook. I want to rank these values from 1-6, which is simple using an =RANK. My issue is that sometimes two of these values could be the same. Is there a way to rank all values, but if there are duplicates assign them a random rank that isn't used by another number in the range?