Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Smile golf handicap resolution

I have a formula which looks at the figures in the next 20 cells in a row, selects the lowest 10 of those numbers, averages them & multiplys that result by 0.96.
as follows

=AVERAGE(SMALL(INDIRECT("F8:Y8"),{1,2,3,4,5,6,7,8, 9,10}))*0.96

I need it to always be the next 20 even when new cells are inserted and to ignore empty cells or zeros.

Can someone help please ?

I am not good with formula so be kind.

Last edited by malaus1 : July 23rd 10 at 04:47 AM Reason: Have part of the solution
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another golf handicap question JoeM Excel Discussion (Misc queries) 5 May 1st 08 05:44 PM
Golf Handicap Anomoly.... Bill Foley Excel Worksheet Functions 7 December 23rd 06 11:45 PM
golf handicap neo314trinity Excel Discussion (Misc queries) 5 March 15th 06 06:46 PM
golf handicap Phineus Excel Discussion (Misc queries) 4 July 4th 05 03:16 AM
Golf Handicap Dick Gwin Excel Worksheet Functions 3 March 2nd 05 03:07 PM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"