ranking values

I have attached a worksheet so that it will make more sense.

I just want to be able to plug in values in "Value B" and have a macro automatically sort in the correct order for the "RANK" columnn. The higher percentages get first placing and so on starting at 8 and going down to 1.

This will be for a March Madness type bracket.

The catch: Value A is a static value and will never change.

Thoughts?

Thanks for the help!

You could do ths quite easily with a formula, i.e. in C3 copied down

=RANK(B3,B$3:B$10,1)

Awesome. Thanks.

2 More questions. How do I sort a column of negative numbers and have it sort by the highest negative number?

Also, is there a way to have a row be highlited when it is the highest of the group? Like a conditional format?

Thanks!