I am using excel to take projections for my upcoming fantasy baseball draft. I will use this to draft my team. My main question is
1) can how can I remove players who have been drafted so my file no longer counts them as a future available pick?
And 2) is there a way to post player names (or at least my projected points) for the next 3 players (Undrafted) at each available Position? The idea here would be to for the cell to update following every drafted player.
Would anyone be able to please explain to me how this can be done?
1) can how can I remove players who have been drafted so my file no longer counts them as a future available pick?
And 2) is there a way to post player names (or at least my projected points) for the next 3 players (Undrafted) at each available Position? The idea here would be to for the cell to update following every drafted player.
Would anyone be able to please explain to me how this can be done?