List a ranking

  • Thread starter Thread starter Big Bubba
  • Start date Start date
B

Big Bubba

I'm a newbie at this, so help is appreciated.

I have an Excel sheet like this:

Team A .600 =rank(b1,b1:b3)
Team B .750 =rank(b2,b1:b3)
Team C .300 =rank(b3,b1:b3)

I want to get another cell to list how far they are from the #1 rank. So,
cell d1 should be equal to .150 and d3 equal to .450. The percentages will
change frequently, so it needs to figure out what is #1. I know I could
just do =b2-b1 and b2-b3, but only because I can see the b2 is the highest
percentage.

Am I making sense?

Is there a way to do this?

TIA.

BR
 
=MAX($B$1:$B$3)-B1

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top