Hello:
> > I have a problem and I was wondering if you could help? I was designated to do stats for a pool league and there are 100 shooters whose average will change every week, my problem is when I get the stats there are 12 teams with lets say 100 shooters having shot. So if I take the first teams sheet and start to do the averages I have to find where the first players name is in the spreadsheet then go across and enter his stats then find the
second players name in the spreadsheet etc,etc,etc. This will take a lot of
time. Is there a way I could enter the information in one spot and click enter and
send that information to wherever that person is in the spreadsheet? I could
send you a copy of the spreadsheet if you need to see it.
> > Example below
> > column a b c d e
> > row 1 player wins loss 8 run
> > id ball tables
> > breaks
> > 001 3 0 1 1
> > Now after entering this info I click enter this will fly to wherever that player is in the spreadsheet, then I go to the next players stats and enter them in the same place as I entered the first players info and hit enter and that goes to wherever that player is in the spreadsheet etc.,etc, where it will automatically figure out the average of the player. The stats for 8 ball breaks and run tables has nothing to do with averages.
Or do you have a better solution.
Thanks
Ron
> > I have a problem and I was wondering if you could help? I was designated to do stats for a pool league and there are 100 shooters whose average will change every week, my problem is when I get the stats there are 12 teams with lets say 100 shooters having shot. So if I take the first teams sheet and start to do the averages I have to find where the first players name is in the spreadsheet then go across and enter his stats then find the
second players name in the spreadsheet etc,etc,etc. This will take a lot of
time. Is there a way I could enter the information in one spot and click enter and
send that information to wherever that person is in the spreadsheet? I could
send you a copy of the spreadsheet if you need to see it.
> > Example below
> > column a b c d e
> > row 1 player wins loss 8 run
> > id ball tables
> > breaks
> > 001 3 0 1 1
> > Now after entering this info I click enter this will fly to wherever that player is in the spreadsheet, then I go to the next players stats and enter them in the same place as I entered the first players info and hit enter and that goes to wherever that player is in the spreadsheet etc.,etc, where it will automatically figure out the average of the player. The stats for 8 ball breaks and run tables has nothing to do with averages.
Or do you have a better solution.
Thanks
Ron