Hi. I'm in the process of trying to get NBA stats lined up so that I can see the Fantasy Points (FP) Season Average/FP Home/FP Away/FP Last 3 Games/FP L5/FP L10 all side by side. The thing is the names for each of those categories as you see on the left side are not alphabetical, some players are not listed in some games as they have been traded to different teams in the last month.
Note: I'm using a formula for fantasy points
On the right side you will see how I organized them side by side using the names from each category but they are still hard to compare side by side. Is there an efficient way of having just one list of names appear in one column and have the stats I mentioned above right next to them in an organized fashion by taking a list of the people from the last 10 games (those are players that matter) and organizing it in a way where I can match up the Season Avg, Home, Away etc? I am going through 30 teams and it's just very time consuming to do the method that I've started with.
Appreciate the help! Let me know if you have questions about what I'm trying to do.
Please download my excel file here:
http://www.speedyshare.com/JNjwS/NBA-Stat-Sheet.xlsx
Here's where I get my stats from:
http://www.hoopsstats.com/basketball...erstats/15/1/1
Bookmarks