Reverse ranking

J

JBG

My first question, once I delete row 7 how do I get what was row 8 to turn
into row 7. Should I worry about it because it may throw off my forumulas?
My second main question is how do I get a reverse ranking for lack of better
term? For example, basketball scoring high is good "regular ranking." Golf
on the
other hand scoring high is bad. I am trying to rank the last column as if
the rows were golfers and scoring high is bad and should have a high number
not a low number. I am using the =RANK(N4,$N$4:$N$34) formula. This
formula is for basketball and not golf.
I have also tried =1+COUNT($N$4:$N$34)-RANK(N4,$N$4:$N$34) but the ranking
went to 31 when I only have 27 values, it seemed to skip some numbers and I
do not know how or why.
I have tried small but it just says #N/A. The numbers I want to rank is
N4:N34. Hope I have supplied enough info for someone to help me
 
T

T. Valko

once I delete row 7 how do I get what was row 8 to turn into row 7.

Excel automatically does that. If you delete row 7 Excel automatically
shifts everything up from row 8 and below so that what once was row 8 is now
the new row 7.

For a rank where lowest is best:

=RANK(N4,$N$4:$N$34,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top