Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

Average of lowest 5 of 20 values?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fatfreek - 16 Jun 2006 02:25 GMT
The following are what golf handicappers call differential values. I've
listed 25 of them. To compute my golf score handicap I need to take the
average of the lowest 5 of the last 20 of these values, and multiply that by
0.96.
The way I see it, the lowest 5 are 5.55, 6.59, 6.59, 6.59, and 7.64. The
average of these 5 would be 6.6.
Any way I could use my Excel 2003 with some formula?

11.82
13.92
14.96
8.68
17.05
19.15
11.82
13.92
5.55
7.64
14.96
12.87
6.59
11.82
9.73
9.73
6.59
17.05
14.96
6.59
9.73
8.68
7.64
13.92
7.64

Len Miller
Signature

To email reply, eradicate all threes in my SPAM guarded address.

Peo Sjoblom - 16 Jun 2006 02:42 GMT
One possible way

=SUM(SMALL(A1:A20,{1,2,3,4,5}))/5

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging."  Lord Healey

> The following are what golf handicappers call differential values. I've
> listed 25 of them. To compute my golf score handicap I need to take the
[quoted text clipped - 32 lines]
>
> Len Miller
Fatfreek - 16 Jun 2006 03:43 GMT
Peo,

Thanks very much. That works perfect.

Len

Signature

To email reply, eradicate all threes in my SPAM guarded address.

> One possible way
>
[quoted text clipped - 36 lines]
> >
> > Len Miller
Michael M - 16 Jun 2006 02:47 GMT
Hi
Try:

=AVERAGE(SMALL(A1:A25,{1,2,3,4,5}))

will do the trick

HTH
Michael M

> The following are what golf handicappers call differential values. I've
> listed 25 of them. To compute my golf score handicap I need to take the
[quoted text clipped - 31 lines]
>
> Len Miller
Fatfreek - 16 Jun 2006 03:43 GMT
Michael,

I also tried your solution and it works. Thanks.

Len

Signature

To email reply, eradicate all threes in my SPAM guarded address.

> Hi
> Try:
[quoted text clipped - 41 lines]
> >
> > Len Miller
Michael M - 16 Jun 2006 03:49 GMT
Thanks for the feedback, glad something met your needs

Regards
Michael M

> Hi
> Try:
[quoted text clipped - 41 lines]
> >
> > Len Miller
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.