I have come to realize that I know less about Excel than I thought. Please
help. I am constructing a growing database of golf scores from which I am
performing simple calculations (sum, average, standard deviation) for each
player represented. I add about 150 rows of information (one per player) per
week, then sort it by player name. The problem I am running into is when I
do this is changes the locations of my calculations into my summary table.
This requires me to manually adjust them, taking way to much time. In the
end I will have about 250 players who have played 1 to 20 tournaments. The
length of my raw data will be around 4000 lines.