Thanks for your suggestion. I have attempted the instructions in the link
but am not finding success. Perhaps, if I could send you or anyone else a
small sample of my project, it would make more sense.
"Peo Sjoblom" wrote:
> http://www.contextures.com/xlNames01.html#Dynamic
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "duchem02" <(E-Mail Removed)> wrote in message
> news:CDD9A70B-0DB9-4888-BE73-(E-Mail Removed)...
> > 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.
>
>
>
Similar Threads
