Hi Biff I got it to work after working with it. Thanks Much

"Biff" wrote:

Post the *EXACT* formula you tried.

Biff

"Karl" wrote in message
...
Hi Biff or Dave when I put this formula into my cell c6 on the results
page i
get #name? and no value. I don't know what i did wrong. Thanks Karl

"Biff" wrote:

Try this:

=SMALL((Sheet1!C$7,Sheet1!C$9,Sheet1!C$11,Sheet1!C $13),ROWS($1:1))

Copy down as needed.

Biff

"Karl" wrote in message
...
Hi Dave Thanks. I do have data in cells c6,c8,c10,c12 what adjustments
will
have to be done to the formula then. Thanks Karl

"Dave" wrote:

Hi Karl,
If you haven't got any data in cells C8, C10 and C12, then this will
do
what
you want.
In cell C6 on your results page, paste this formula:
=SMALL(Sheet1!C7:C13,1)
And in cell C7, paste this one:
=SMALL(Sheet1!C7:C13,2)
You'll have to replace the Sheet1 reference to whatever your score
sheet
is
called.

Hope that helped.
Dave


"Karl" wrote:

Hi I have a sheet that has 4 players per team.Their scores are
recorded
in
cells c7,c9,c11,c13.Now i want the 2 best scores to be recorded in
another
sheet that i have named results in cells c6,c7.So only the 2 best of
the 4
scores will be in the result sheet. Thanks Karl