Excel 2003 formula to find % in pivot and rate with number

I am trying to find a formula that will search a column in a pivot table find the highest % and rate it with a number. The one I'm currently working on has 8 variables, I would like it to see the highest % 29.17 and rate it 8, then find the next highest % 27.08 and rate that 7 and so on down to 0% and rate that 1. The cells in the pivot table may change over time so I can't do a formula that says if this cell = this than 8 as in the future that cell might have the lowest %.

Thank you in advance

will that work as I have two data's being evaluated? example attached

I think I may have figured it out. Still working on it, I'll let you know.