software

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: www.excelforum.com/member.php...oamp;userid=31621
View this thread: www.excelforum.com/showthread...hreadid=513137=LARGE($A$1:$A$5,1) ' wil get Highest

=LARGE($A$1:$A$5,2)
Will get next highest, etcquot;JeffShonequot; gt; wrote
in message ...
gt;
gt; Hi I hope someone can help me.
gt;
gt; I have an exel spreadsheet that I am using to record the scores for a
gt; Quiznight. The teams are listed in one column, the table number they
gt; are sat at in another and the scores they have attained in the final
gt; column. What I want to be able to do is use this data to import into a
gt; powerpoint presentation, (I have already worked out to do this) but
gt; what I want it to show is only the top 10 scores. There are 54 teams
gt; all together. Can anyone give me an idea how to do this?
gt;
gt; Any advice would be really appreciated.
gt;
gt; Regards
gt; Jeff
gt;
gt;
gt; --
gt; JeffShone
gt; ------------------------------------------------------------------------
gt; JeffShone's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31621
gt; View this thread: www.excelforum.com/showthread...hreadid=513137
gt;

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: www.excelforum.com/member.php...oamp;userid=31621
View this thread: www.excelforum.com/showthread...hreadid=513137