Excel Help for Fantasy Football

[Dallas32]

I am currently tracking each player that is drafted during our draft. (Round, Team #, Player, Position, & Fantasy Team Name).

What I would like to do is when the draft is done, I would like to run a report by Position (including Player name and Fantasy Team Name).


Any help for this Novice user would be MUCH APPRECIATED!!!!! Please reply ASAP!!

Thanks!!!!

 

[Chip Pearson]

I think you need to provide more details about what exactly you
want to do. What, exactly, does "run a report by Position"
really mean? Sorted by position?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I am currently tracking each player that is drafted during our

draft. (Round, Team #, Player, Position, & Fantasy Team Name).

What I would like to do is when the draft is done, I would like

to run a report by Position (including Player name and Fantasy
Team Name).

 

[Dallas32]

Yes. I want to run a report that is sorted by postions.

For instance, if the following 10 players were selected, I want to run a report by position that would show 8 RB's, 1 QB, & 1 WR being selected.

PLAYER, POSITION, TEAM
1. Priest Holmes, RB, Kansas City
2. LaDainian Tomlinson, RB, San Diego
3. Clinton Portis, RB, Washington
4. Ahman Green, RB, Green Bay
5. Deuce McAllister, RB, New Orleans
6. Jamal Lewis, RB, Baltimore
7. Shaun Alexander, RB, Seattle
8. Edgerrin James, RB, Indianapolis
9. Daunte Culpepper, QB, Minnesota
10. Randy Moss, WR, Minnesota

 

[Frank Kabel]

Hi
you may take a look at pivot tables to create this kind of report:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm