(06-23-2017, 10:36 AM)timeconsumer Wrote:Pro-tip:
In the index (where it looks like you copy and pasted your receiving stats from) copy and paste the team rosters into separate sheet to get their attributes. Then use either a vlookup() formula or an index-match formula (if you're pro) to get excel to insert a player's speed, agility, hands etc etc into the same sheet as their receiving stats for you. Turns a 2 hour data collection session into 5 minutes.
I have no idea what any of that means lol, this was my first time "using" Excel.