Can I do this?

[bizzydizzy]

I draft a bunch of fantasy football teams and would like to take all the players I have drafted (from about 20 drafts, 28 players each) place them into an Excel file to determine ownership percentages. Trying to determine my exposure to player.

The app I use to do the drafts allows me to export the draft in this format:

DRAFT PICKS
pick,overall,franchise,player,position,NFL team,notes
"=""1.01""",1,Saquon's Quads 6.6.19,Saquon Barkley,RB,NYG,
"=""1.02""",2,Maverick1,Ezekiel Elliott,RB,DAL,
"=""1.03""",3,Lap19,Christian McCaffrey,RB,CAR,
"=""1.04""",4,June,Alvin Kamara,RB,NO,
"=""1.05""",5,35DonkD,David Johnson,RB,ARI,
"=""1.06""",6,Shake n Bake,DeAndre Hopkins,WR,HOU,
"=""1.07""",7,BallyHoo,Travis Kelce,TE,KC,
"=""1.08""",8,Doubleteams,Zach Ertz,TE,PHI,
"=""1.09""",9,Burnt Weenie Sandwich,LeVeon Bell,RB,NYJ,
"=""1.10""",10,WonAndDone 6/6,Melvin Gordon,RB,LAC,
"=""1.11""",11,Bang Your Tuna Girlfriend,Davante Adams,WR,GB,

How would I isolate each of my picks? Kinda new, but able to learn!

Thanks!

 

[ekrause]

Yes, you can do this. But the devil's in the details.

I can provide a high level assessment of the steps I would take to accomplish this but you may need to massage your data more than I'm suggesting. I'm assuming you are on a PC. The required Mac steps may be slightly different (depending on your version of Excel there can also be differences to this outline).

Step 1. Copy & paste all data into excel
Step 2. (assuming there are no franchise/player names with commas - you'll want to check this) click the "Text to Columns" button under the Data Tab
Step 3. Select "Delimited" click next
Step 4. Check "Comma", click finish

Your data should now be in the following columns: pick, overall, franchise, player, position, NFL team, notes

Step 5. Add column headers
Step 6. Select all data and add a filter (found under the Data Tab)
Step 7. Under franchise header uncheck select all box
Step 8. Select your franchise names
Step 9. Copy filtered data to new worksheet
Step 10. Find list of all players (alternatively you can copy you list of player names and remove duplicates)
Step 11. Write Countif Formula from your data table
Step 12. Pray that everything worked correctly
Step 13. Divide each countif by number of leagues you're in

Step 14. ? if issues come back and ask for more assistance.

 

[bizzydizzy]

Thanks for the help. Love "pray everything works out!"

 

[bizzydizzy]

Managed to get all 15 teams into one sheet. I am not clear on how to simply determine how many times players were drafted. After that is determined, then divide by 15 like you said, to determine percentage.

 

[ekrause]

Assuming you only have your teams on a sheet, you will want to use a countif formula which looks like this : =countif(

#VALUE!