Skip to content

Excel help

Featured Replies

I run a small club and need to be able to find teh arverage form the best 4 scores from a total of 12 scores.

i.e.

31 40 42 28 0 41 0 28 28 32 35 39

bet 4 scores are - 40 42 41 39

average is 40.5

Many thanks in advance to anyon ethat can come up with a formula to do this.

That's some good formula :thumbup:

  • Author

Easy peasy :D

excellent - thank you :thumbup:

  • Author

Now, next question

How can I automated counting the numebr of events attended

31 40 42 28 0 41 0 28 28 32 35 39

In this list of 12 events there were 2 "zero returns" = 10 events attended.

I am assuming that all competitors will score at least something and a "0" = no attendance.

  • Author

Here we go B)

top man :thumbup:

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.