Hi,

I am having a problem figuring out how to create a drop down list that reduces after every selection. I am trying to create a spreadsheet that records individual players selections of team names. The team names cannot be selected again until all the team names have been used.

I have created the drop down list using Data > Validation > List > the list itself, but I can't figure out how to make the next selection reduce.

I have browsed the forum site and found that I can use the OFFSET function with a nested COUNTA function, but all I get in the output is ####.

Do I have to use the formula in the Data > Validation > List dialogue box and use a name for the team names?

I am using Excel 2003.

Thanks for any help I can get.