Code: Select all
=MATCH(B36;B3:B33;0)
As it sits now you have a drop down menu to select the rank and then you enter the numerical % as you progress through the rank below it.
Just thought that I might help you out with Open Office work here. I do think though that the MATCH function works the same in Excel, though I do not have Excel here to verify.