View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Berty Berty is offline
external usenet poster
 
Posts: 2
Default Average of lowest 6 from a range - 1 attachment

No help now needed ... found "small" function and have been
able to work out most of the rest !!

Berty






Berty wrote in
:

Help!

Problem: The top 8 players at my golf club (based on the best 6
scores from a series of competitions) will qualify for further
competition. How do I set up a spreadsheet that will automatically
show a running average score for everyone as the season progresses -
but ignoring zero entries and keeping the maximum number of qualifying
competitions to 6?