Doug --

That's the cool thing about pivot tables -- you can pull out data by game,
or chronologically, or home/away chronologically, or whether they tied their
left shoe first on away games, whatever.

Try it you'll like it.

"DougN" wrote:

Thanks for the quick help guys.

Pdberger- I have a cell on each sheet that signifies where the game is Home
or away...its basically noted by an "H" or an "A". I was thinking that I
could just average the cells IF cell#=H.

I can put it all on one table, but I would like to be able to seperate them
so that I can't print game by game tables if my head coach asks for them.