title: Permutation to find the best teams possible
body: <p>I'm trying to ask this a different way to get some responses. I've been looking into permutations to find the best value for a team except I can't seem to find any material that gives me a clear understanding of what I need to do.. beginner at creating permutation tables in excel.</p>
  
  <p>what I'm looking to accomplish. I want to get the top 100 permutations (or more if possible) of the possible fantasy football teams. </p>
  
  <p>I'm not quite sure how to set this up since I will need each permutation to include each position as follows QB, RB, RB, WR, WR, TE (6 starters). And since there are different number of players available for each position I'm not sure how to put all of this together or what the best method would be and so I've asked for help!</p>
  
  <p>what I want the outcome to be.</p>
  
  <pre><code>Position QB   RB   RB   WR   WR    TE   Total
  Fantasy 350  110 115  220  120   125   1040
  </code></pre>
  
  <p>and have the above format continue throughout the permutations figuring out the best possible team. </p>
  
  <p>Players would come from different columns like below:</p>
  
  <pre><code>qb               rb
  peyton 350   jamaal 235
  drew   345
  </code></pre>
  
  <p>I'm not sure if this is possible, but I have found a macro that will give me just the possible position outcome (QB, RB, WR etc) but I can't seem to figure out how to combine the points to the positions and show all permutations for each player at their respective positions.</p>
  
  <p>Thanks again.</p>