I need help with a formula or a sorting action

M

mshintz

I am using XL 10.2.3 for Mac. I am using a spreadsheet to track scores
at a race track. We have 10 weeks of racing and I want to know the
total of the top 8 scores for each racer. There are 7 different
division of racers and each division has a different number of racers.
I tried sorting each row then taking the top 8 scores that way, but I
could only get one row to sort at a time. Got any suggestions?
 
G

Guest

LARGE(A1:A100,1) ' largest value in col a
LARGE(A1:A100,2) ' sekond large and so on

"(e-mail address removed)" skrev:
 

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

In Exel how can I select and sum the top two values in a column? 2
Ranking a list 4
sorting rows based on value 7
sorting with linked worksheets 1
sorting and ranking 2
How can I total the top 9 scores of 12 weeks in a sporting contest 8
Help With A Golf League 4
Creating smaller and larger cells on the same sheet 1

Top