J
joyjoy329
Hi,
I'm currently creating a data base for my basketball league, what i
have is 14 different game sheets which will automatically calculate the
total statistics for me including percentage of FG, total rebounds,
total assists...etc for each game..
from D4 to Q18 is the data i'll enter the sigle gmae stats (for all
players) i recorded from the game... and from S4-CE18 is the accumulate
stats which the players involve in (like the avg rebounds they get for
one game, the total rebounds they have so far)...
all totals are using previous sheets to get the value (by adding up the
previous sheet's total, like =Q5+'Game 13'!CD5...
My question is how can i creat seperate the top 50s page (showing who
got the most rebounds and how many in total ) using the data i got from
the previous pages which will automatically updated whenever i enter the
new game statistics in??
Joy
I'm currently creating a data base for my basketball league, what i
have is 14 different game sheets which will automatically calculate the
total statistics for me including percentage of FG, total rebounds,
total assists...etc for each game..
from D4 to Q18 is the data i'll enter the sigle gmae stats (for all
players) i recorded from the game... and from S4-CE18 is the accumulate
stats which the players involve in (like the avg rebounds they get for
one game, the total rebounds they have so far)...
all totals are using previous sheets to get the value (by adding up the
previous sheet's total, like =Q5+'Game 13'!CD5...
My question is how can i creat seperate the top 50s page (showing who
got the most rebounds and how many in total ) using the data i got from
the previous pages which will automatically updated whenever i enter the
new game statistics in??
Joy