Question on Filling Out Fantasy Roster

bubbataks

New Member
Joined
Mar 6, 2019
Messages
10
Hello,

I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team.

The player's name is in Column B.
The player's position is in Column C.

iMAAAAAElFTkSuQmCC


On the same tab, I'd like to place each player into a roster spot which is the following for 23 spots:
The first position "C" is in B30. The last position "Bench" is in B52.

C
1B
2B
3B
SS
OF
OF
OF
Util
Util
SP
SP
RP
RP
P
P
P
P
Bench
Bench
Bench
Bench
Bench

So if a player qualifies for the C position, I'd like them to go in that row.

If a position is full (example the C spot is filled and another C is drafted), I'd like the player to go to the Bench.

To further complicate things, not sure if there is a way to handle multiple positions. For example if a player has multiple positions such as 2B and 3B, is it possible to move them to first open spot they qualify for?

Thank you so much for looking.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

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