View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Baseball Stat Problem

I have been using Excel to compile baseball statistics for a list of
192 players. My problem is that the website I use to generate the
statistics into excel only allows so many stats at a time, AND
generates them for nearly 2000 players. What I have been doing for
each report is comparing the the master list (192 players) with the new
larger list alphabetically, deleting all the players not among the 192,
and then copy/pasting once the lists are identical.

Needless to say this is very time consuming and annoying. I KNOW there
must be a way to let excel do all the work, even for as many stats at a
time as I have. Perhaps vlookup??

Any help on this would be greatly appreciated.