Average of top 3 numbers.

[Guest]

Still the same, what can be the problem??

 

[Guest]

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

David McRitchie skrev:

 

[Guest]

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

 

[Guest]

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

Still the same, what can be the problem??

 

[Guest]

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

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

Still the same, what can be the problem??

 

[Guest]

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? (e-mail address removed) I would be very happy if you were so kind.

Belzbub

Ron Coderre skrev:

 

[Guest]

Check your email.

Good luck.

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