Hi Fellas,

Been a while and glad to be back on the forums (unfortunately have not done a lot of excel recently )

I have two columns with the following data set:
Column A Column B Column C
0 11.5
0 13.5
0 12.2
1 14.0
1 7
1 12
0 2
0 3
0 9.6
1 2.3

I want to run a percent rank function in column C where I am only calculating the percent rank on numbers which have a 1 associated with them in Column A. So for example, the first number 11.5 would have a zero next to it in column C... all of the numbers until the fourth number would have a zero next to them. Then the 4th number would have a value of 1 (because its the largest number)... the last number (2.3) would have a value of 0 as its in the zero percentile. The numbers in between would correspond to the percentile in which they lie (i.e. numbers 7 and 12, roughly .33 and .66 respectively). Any thoughts for how to do this in Column C?

Thanks!

Larry