Can I do this?

bizzydizzy

New Member
Joined
Aug 26, 2019
Messages
3
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!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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. :)
 
Upvote 0
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.
 
Upvote 0
Assuming you only have your teams on a sheet, you will want to use a countif formula which looks like this : =countif(
#VALUE!
 
Upvote 0

Forum statistics

Threads
1,223,967
Messages
6,175,664
Members
452,666
Latest member
AllexDee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top