Originally posted on the end of this thread.
Forgive me for butting in - but, I have a similar problem. I too would like to average golf scores using a spreadsheet. Instead of 5 scores - our group uses the 4 lowest of the last 6 scores though. I have data on 2 spreadsheets where one is all of the scores with the latest score added to the end column. The other sheet I also insert a new column and enter the latest scores in that column. I can use either method - but, would prefer the one where a new column is inserted each time I enter scores. Like the other guy - I have players that do not play on each occasion and so there is nothing entered for them in that date. That results in blank cells that must be ignored to get the 6 latest scores for the calculations. One additional thing I would like to be able to do is to either bold, paint the cell or copy the 4 scores that were used for the calculations to a cell below where they were taken from. My final average will be displayed in the 2nd column rounded up or down to the nearest whole number. The next time scores are entered - I would like to remove that highlight from the previous calculations. Any suggestions would be a big help.
Ray
Bookmarks