Hello,
I am creating a workbook to manage golfer scores, teams, winnings, handicap, ect. I am having trouble with the statistics sheet.

I Need A Sub To:

1. Column "B" , take the average of the lowest 5 numbers in columns "AB" though "AU"

2. Column "C" , take the average of the lowest 10 numbers in columns "G" through "Z" divided by 0.96

3. Column "D" , take the average of the lowest 10 numbers in columns "AW" through "BP"

this needs to happen for each row where there is a name. (names added daily)

I have included a similar sheet as the one i am working with along with some command buttons typically not included. Should show some of the problems I am having.
Thank you for your help