OK, I swear I have searched up and down for all words nd phrases I can think of but I can't find how to do this. I am not and Excel expert in any fashion. But I think that what I am trying to do is fairly simple or at least would be for the experts here in this forum.
I would like to have a drop down list in every cell. The list is dynamic to the point that as each previous cell in the row is selected, the list removes that selection. So if the list has Apple, Orange, Banana, Lemon, Lime in it and for the first selection in the row (C2) Lemon is selected from the dropdown, then in (C3) the only choices are Apple, Orange, Banana, Lime.
Does that make sense? So it is for a Football pool that is a single elimination pool but you can't choose the same team twice. Each player obviously has their own set of teams but the team has to be removed from the list each week.
I searched for many iterations of how to describe this but came up with nothing similar to text conditional list removal per row.
I appreciate the site and the ability to be able to ask and search for these kinds of things online. How exactly did we get through life before the internet again?
I would like to have a drop down list in every cell. The list is dynamic to the point that as each previous cell in the row is selected, the list removes that selection. So if the list has Apple, Orange, Banana, Lemon, Lime in it and for the first selection in the row (C2) Lemon is selected from the dropdown, then in (C3) the only choices are Apple, Orange, Banana, Lime.
Does that make sense? So it is for a Football pool that is a single elimination pool but you can't choose the same team twice. Each player obviously has their own set of teams but the team has to be removed from the list each week.
I searched for many iterations of how to describe this but came up with nothing similar to text conditional list removal per row.
I appreciate the site and the ability to be able to ask and search for these kinds of things online. How exactly did we get through life before the internet again?