Dropdown lists using each value only once
 

Is there a way to have 34 total dropdowns (in two different colums) that can
each select a number 1 through 34 but each number can only be used ONCE?

Dropdown lists using each value only once
 

Yes, you can do this.

Tell us *exactly* where these drop downs will be located. (hint: don't just
say column A and column B. Tell us *exactly* where in column A and column B)

--
Biff
Microsoft Excel MVP


"bcbrown7" wrote in message
...
Is there a way to have 34 total dropdowns (in two different colums) that
can
each select a number 1 through 34 but each number can only be used ONCE?

Dropdown lists using each value only once
 

That would be great! Here are all of the cells that will need a dropdown:

B7, R7, B13, R13, B19, R19, B25, R25, B31, R31, B37, R37, B43, R43, B49,
R49, B55, R55, B61, R61, B67, R67, B73, R73, B79, R79, B85, R85, B91, R91,
B97, R97, B103, R103

Brian


"T. Valko" wrote:

Yes, you can do this.

Tell us *exactly* where these drop downs will be located. (hint: don't just
say column A and column B. Tell us *exactly* where in column A and column B)

--
Biff
Microsoft Excel MVP


"bcbrown7" wrote in message
...
Is there a way to have 34 total dropdowns (in two different colums) that
can
each select a number 1 through 34 but each number can only be used ONCE?


.

Dropdown lists using each value only once
 

Your are BRILLIANT! It works perfectly. Thank you so much!!!

Brian

"bcbrown7" wrote:

Is there a way to have 34 total dropdowns (in two different colums) that can
each select a number 1 through 34 but each number can only be used ONCE?