Average of top 3 numbers.

R

Ron Coderre

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
 
B

Belzbub

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 said:
Still the same, what can be the problem??
Click to expand...
Click to expand...
 
R

Ron Coderre

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 said:
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 said:
Still the same, what can be the problem??
Click to expand...
Click to expand...
Click to expand...
 
B

Belzbub

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? [email protected] I would be very happy if you were so kind.

Belzbub

Ron Coderre skrev:
 
Top