| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the top ten scores
Hi I hope someone can help me. I have an exel spreadsheet that I am using to record the scores for a Quiznight. The teams are listed in one column, the table number they are sat at in another and the scores they have attained in the final column. What I want to be able to do is use this data to import into a powerpoint presentation, (I have already worked out to do this) but what I want it to show is only the top 10 scores. There are 54 teams all together. Can anyone give me an idea how to do this? Any advice would be really appreciated. Regards Jeff -- JeffShone ------------------------------------------------------------------------ JeffShone's Profile: http://www.excelforum.com/member.php...o&userid=31621 View this thread: http://www.excelforum.com/showthread...hreadid=513137 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the top ten scores
=LARGE($A$1:$A$5,1) ' wil get Highest
=LARGE($A$1:$A$5,2) Will get next highest, etc "JeffShone" wrote in message ... Hi I hope someone can help me. I have an exel spreadsheet that I am using to record the scores for a Quiznight. The teams are listed in one column, the table number they are sat at in another and the scores they have attained in the final column. What I want to be able to do is use this data to import into a powerpoint presentation, (I have already worked out to do this) but what I want it to show is only the top 10 scores. There are 54 teams all together. Can anyone give me an idea how to do this? Any advice would be really appreciated. Regards Jeff -- JeffShone ------------------------------------------------------------------------ JeffShone's Profile: http://www.excelforum.com/member.php...o&userid=31621 View this thread: http://www.excelforum.com/showthread...hreadid=513137 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the top ten scores
Thanks Jim Do I need to make another spreadsheet for this and then link powerpoint to this new spredsheet? Could you type out the formula for me? Regards Jeff -- JeffShone ------------------------------------------------------------------------ JeffShone's Profile: http://www.excelforum.com/member.php...o&userid=31621 View this thread: http://www.excelforum.com/showthread...hreadid=513137 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| Football Scores | Excel Discussion (Misc queries) | |||
| Golf Handicap Using Last 5 Scores | Excel Worksheet Functions | |||
| finding multiple MIN's | Excel Worksheet Functions | |||
Linear Mode
