how to count top ten results from 16?

  • Thread starter Thread starter iamstellaman
  • Start date Start date
I

iamstellaman

Hi, i have alimited knowledge of excel,
i am trying to compile a points table for a 16 round race meeting, onl
the top ten scores are to count though, how do i get excel to do this??
Thanks in anticipation!!
Mar
 
=LARGE($A$1:$A$20,1)
=LARGE($A$1:$A$20,2)

will give you Top 2 in range of 20
HTH
 
Hi
have a look at the LARGE function. e.g. for summing use
=SUMIF(A1:A100,">=" & LARGE(A1:A100,10))

Note: may not work if you have duplicates in the range. Another
version:
=SUM(LARGE(A1:A100,{1,2,3,4,5,6,7,8,9,10}))
 
Are you trying to compile a Top 10 list of racers based on thei
scores?
 
You must log in or register to reply here.

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

Automatic Sorting of Top Ten values in a table 2
Top Ten Word count 6
Top Ten 3
Extra spaces at top of page 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Query the top top ten by category? 2
Finding the top ten scores 2
How do I change Excel columns from alphabetical to numeric? 6

Back
Top