ScottHope:
This might work for you in Excel Big
{=AVERAGE(SMALL(*your scores array goes here*,ROW(INDIRECT("1:50"))))}
You'll notice the formula has curly brackets at either end, you don't type these in, the formula is entered using the key combo CTRL + SHIFT + ENTER because it is an array formula, the curly brackets will then appear automatically & there's no need to do any sorting beforehand.
(The highlighted number can be altered to suit the quantity of values you wish to average, so you could change it to 500 if you were a legend or 40 if you were a master etc).
Hope that helps. : )
What I ended up doing is creating two dedicated pages in my wgt_tour workbook. Page 1 is Stroke Play Avg. It contains scores for ALL ranked rounds on regulation par 70, 71, or 72 courses. In column A is the course name, column B is the score, and column C is the date played. In cell G1 I have the following formula: =AVERAGE(IF(B1:B500<>0, B1:B500,"")). B500 is just a placeholder; I used that cell so I could enter many scores and not have to keep updating the formula constantly.
The second page of the workbook is Saturated Avg. I copied the 50 entries from page 1, and each time I shoot a round lower than the highest score on the Saturated Avg. page, I manually replace the high score with the lower one. I also have an x in column D on the Stroke Play Avg page, so I know which scores are currently being used to calculate my saturated avg. This is a much simpler calculation, I just use =AVERAGE(B1:B50). It does require a little bit more work on my end, but it does have the benefit of showing me which rounds are included in the saturated average, as well as letting me know what score I need to beat to lower my average.
PaulTon: Royal St. Andrews? Not a course I've ever heard of, is it new?
I could be wrong about this one, since I'm not from the area, but I understood Saint Andrews to be just the common name. The 'official' name being The Royal and Ancient Golf Club of Saint Andrews. Even though I disagreed with their now repealed policy of no female members, given their history and importance to the sport I felt like Royal was a title that they have earned, so I personally commonly refer to the course as Royal Saint Andrews. It may be a bit unusual to list it this way, but as far as I know it isn't totally wrong.