Drop Down Menu help

M

mattmidgett

I am putting together a spreadsheet for a Bowl Pick'Em league. I am trying
to have a column for confidence points that has a drop down list in each cell
with the option to pick from 1-34. I have figured out how to have a list
that allows you to pick from 1-34, but what I really need to figure out is
how to make it to where I can only select each number one time. For
instance, if I choose 7 in the first cell, when I go to the cell below it I
want to have the option to pick all numbers 1-34 EXCEPT 7. Is there a way to
do this?

As of now I have it set to Data>Validate choose "list" then have the range
of cells showing a column that has the numbers 1-34.

Thanks for any help you might be able to give me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple-column Drop-down 2
Drop down list 2
Linking Excel drop down lists 2
Select drop down menu option using libre-calc macro 0
Filtered drop down list 2
Excel Drop Down Box 2
Data-Validation -List - Pick from a drop down menu 4
Max number of drop-down list elements in excel 3

Top