LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Average of last 3 non-0 numbers in row?

I am secratary of golf league and handicap is calculated of the average of
the last 3 rounds played. If a player is absent for a week, there is a zero
in his score. This would be a rolling average of coarse.
 
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
Average of numbers under 10 Linda \(RQ\) New Users to Excel 6 October 11th 09 12:03 PM
average a continuous group of numbers and negative numbers are 0 Dumbfounded Excel Worksheet Functions 3 October 15th 08 11:53 PM
Average highest 16 numbers on a column of 32 numbers Frank[_10_] Excel Worksheet Functions 3 May 2nd 08 02:44 AM
average of kth largest numbers in an array of n numbers georgeb Excel Worksheet Functions 6 September 5th 05 05:57 AM
Average of numbers in column between to other numbers Ditandhischeese Excel Discussion (Misc queries) 2 March 31st 05 03:35 AM


All times are GMT +1. The time now is 11:11 AM.

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"