Good Morning,
I work at a golf course and we have a weekly outing. Each week, I post the scores and their averages. Formula for that is not a problem. We are in week 7 and when we get to week 11, I need to change my formula to give me the top 10 scores only and to give me their average score. Thank you for any help.
[Solved] Averaging the top 10 scores out of 20
[Solved] Averaging the top 10 scores out of 20
Last edited by MrProgrammer on Sat Jul 20, 2019 4:08 pm, edited 1 time in total.
Reason: Tagged ✓ Solved
Reason: Tagged ✓ Solved
Open Office 4.1.3
Windows 7
Windows 7
Re: Averaging the top 10 scores out of 20
Use a helper table filled-in with 10 formulas by usage the function LARGE() Then calculate the average of the helper table.
Note:
For the state " less than 10 data exists", you need use a condition in the formulas to examine the COUNT() of the data.
Note:
For the state " less than 10 data exists", you need use a condition in the formulas to examine the COUNT() of the data.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Averaging the top 10 scores out of 20
Pivot tables are easy.
- Attachments
-
- pivot_t98676.ods
- (45.26 KiB) Downloaded 100 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- MrProgrammer
- Moderator
- Posts: 4908
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Averaging the top 10 scores out of 20
Hi, and welcome to the forum.
Type that then press ⇑⌘Enter on a Mac, Ctrl+Shift+Enter on other platforms. If you press Enter by accident, use Edit → Delete Contents → Delete All → OK, then retype the formula and try again. If you need any additional assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
=AVERAGE(IF(COUNT(cells)<11;cells;LARGE(cells;{1;2;3;4;5;6;7;8;9;10})))mrmark wrote:We are in week 7 and when we get to week 11, I need to change my formula to give me the top 10 scores only and to give me their average score
Type that then press ⇑⌘Enter on a Mac, Ctrl+Shift+Enter on other platforms. If you press Enter by accident, use Edit → Delete Contents → Delete All → OK, then retype the formula and try again. If you need any additional assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).