D
duchem02
Please help..... I am trying to develop a program that will accumulate and
report golf statistics for as many as 250 players who have played in 1 to 20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total score,
total money won, place in the tournament. From the raw data I perform simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments) for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand how
this is compounded by the time I get to the bottom of the summary report. My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple SUM
formula. Any suggestions would be greatly appreciated.
report golf statistics for as many as 250 players who have played in 1 to 20
tournaments. I store my raw data in columns containing player name, 1st
round score, 2nd, round score, 3rd round score 4th round score, total score,
total money won, place in the tournament. From the raw data I perform simple
calculations (SUM, AVE, STDEV, MIN, MAX) which get stored in a summary
report. Each line of raw data is for a specific player in a specific
tournament. My frustration comes from adding new data from the latest
tournament. How do I control ranges and summarize each players data onto the
summary report without having to manually re-adjust the formulas? I have
tried setting up a 20 row range (one row for amaximum of 20 tournaments) for
each player. I then add the new weeks data (brining me to 21 lines per
player) and then delete an empty row (bringing me back to 20 rows perplayer).
However, Excel deletes a row from my formula without recognizing the added
data leaving me with formulas that are 19 rows long. You can understand how
this is compounded by the time I get to the bottom of the summary report. My
summary report contains 28 columns of crunched data from 8 columns of raw
data. I have tried an OFFSET formula but it behaves the same as a simple SUM
formula. Any suggestions would be greatly appreciated.