I am trying to use the PERCENTRANK function to find what percentile the 'answer' ranks within column 'B'. Starting at "Dim x As Double" is where the PercentRank function starts, I just included the rest of the code to show what else I am doing. I am trying to use the PERCENTRANK function to