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