leaderboard style chart??? help!

  • Thread starter Thread starter evanmc7
  • Start date Start date
E

evanmc7

This is probably an easy question to most. I am hosting a tournament an
need to be able to enter all scores and then have it give me 1st, 2n
3rd etc. Can anyone help? I have fill out all the names, can get th
sum function to give total but not in order of name and score.
Thank
 
Can you sort your data by the score column?
This is probably an easy question to most. I am hosting a tournament and
need to be able to enter all scores and then have it give me 1st, 2nd
3rd etc. Can anyone help? I have fill out all the names, can get the
sum function to give total but not in order of name and score.
Thanks
Click to expand...
 
Save your workbook first--just in case!

Select your data (all the columns and all the rows -- but only include the last
header row if you have more than one).

Data|Sort|
choose the field that holds the scores
If low scores are good, then sort by that field in ascending order. (Like
golf.)

If high scores are good (like bowling), then sort in descending order.

Be careful. If you don't sort the whole range, you could be messing up your
data.

If you mess up, just close without saving. Reopen and try again.
 
Back
Top