Average of top 3 numbers.

Still the same, what can be the problem??

Tried it now but it doesent help. And i have english version.

David McRitchie skrev:

and so have you then found the problem and solution
was actually expecting you to use a helper column checking individual cells.

Or select the entire column and use GoTo (ctrl+g -or- Edit, goto), special
then either constants or formulas, and then
numbers

Peo Sjoblom asks an interesting question. What international settings are
you using? Perhaps your delimiters are NOT the same as the ones we're sending
you.

Try using different delimters.
Perhaps semicolons: =AVERAGE(LARGE(E6:W6,{1;2;3}))

or maybe this will work:
=AVERAGE(LARGE(E6:W6,ROW(1:3)))
Note: commit that array formula by holding down [Ctrl]+[Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

Still the same, what can be the problem??

Still the same. I have put the Excel file on my homepage:
http://home.no.net/belzbub/Bedriftsskyting/index.htm and go to
"stevneoversikt".

Belzbub

Ron Coderre skrev:

Peo Sjoblom asks an interesting question. What international settings are
you using? Perhaps your delimiters are NOT the same as the ones we're sending
you.

Try using different delimters.
Perhaps semicolons: =AVERAGE(LARGE(E6:W6,{1;2;3}))

or maybe this will work:
=AVERAGE(LARGE(E6:W6,ROW(1:3)))
Note: commit that array formula by holding down [Ctrl]+[Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

Still the same, what can be the problem??

First, I had no problem putting the formula into your worksheet.

Second, In your spreadsheet, you have less than 3 numbers in the range
E6:W6 causing the formula to return #NUM!. When I entered a third number, the
formula calculated properly.

I changed the formula to this to trap the "less than 3 numbers" situation:
=IF(COUNT(E6:W6)3,"Less than 3 numbers",AVERAGE(LARGE(E6:W6,{1,2,3})))

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

Still the same. I have put the Excel file on my homepage:
http://home.no.net/belzbub/Bedriftsskyting/index.htm and go to
"stevneoversikt".

Belzbub

Ron Coderre skrev:

Peo Sjoblom asks an interesting question. What international settings are
you using? Perhaps your delimiters are NOT the same as the ones we're sending
you.

Try using different delimters.
Perhaps semicolons: =AVERAGE(LARGE(E6:W6,{1;2;3}))

or maybe this will work:
=AVERAGE(LARGE(E6:W6,ROW(1:3)))
Note: commit that array formula by holding down [Ctrl]+[Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

Still the same, what can be the problem??

What the *#¤*¤!#"@£$ is wrong with this thing..... No matter what i do, copy
the formula and pasting it in the sheet it woun`t work. Can it be something
with the properties in excel? Can you DL the sheet, change it and mail it
back to me? I would be very happy if you were so kind.

Belzbub

Ron Coderre skrev:

First, I had no problem putting the formula into your worksheet.

Second, In your spreadsheet, you have less than 3 numbers in the range
E6:W6 causing the formula to return #NUM!. When I entered a third number, the
formula calculated properly.

I changed the formula to this to trap the "less than 3 numbers" situation:
=IF(COUNT(E6:W6)3,"Less than 3 numbers",AVERAGE(LARGE(E6:W6,{1,2,3})))

Check your email.

Good luck.

***********
Regards,
Ron


"Belzbub" wrote:

What the *#¤*¤!#"@£$ is wrong with this thing..... No matter what i do, copy
the formula and pasting it in the sheet it woun`t work. Can it be something
with the properties in excel? Can you DL the sheet, change it and mail it
back to me? I would be very happy if you were so kind.

Belzbub

Ron Coderre skrev:

First, I had no problem putting the formula into your worksheet.

Second, In your spreadsheet, you have less than 3 numbers in the range
E6:W6 causing the formula to return #NUM!. When I entered a third number, the
formula calculated properly.

I changed the formula to this to trap the "less than 3 numbers" situation:
=IF(COUNT(E6:W6)3,"Less than 3 numbers",AVERAGE(LARGE(E6:W6,{1,2,3})))