Finding the top ten scores

[JeffShone]

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

[Jim May]

=LARGE($A$1:$A$5,1) ' wil get Highest

=LARGE($A$1:$A$5,2)
Will get next highest, etc


"JeffShone" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JeffShone]

Thanks Jim

Do I need to make another spreadsheet for this and then link powerpoint to this new spredsheet? [edit] I just worked out I can add another sheet to display the top ten and then link this into powerpoint. but what formula do I use to search sheet one for the top ten scores and team etc..

Could you type out the formula for me?

Regards
Jeff