My Excel drop-down list eliminates from list options chosen. Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set up a drop-down list for my spreadsheet with the options "Fax, Mail,
Pick-up, Interoffice". When I pick fax, the next block in that column only
gives me the options, "Mail, Pick-up, Interoffice". If I pick one of those
three, the next block has two options. I want to be able to reuse the options
multiple times.

I selected the range G3-G40, went under the Data menu, picked Validation,
picked List from the Allow drop-down box, and entered "=(J2-J5)" in the
Source text box.

What am I doing wrong?
 

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

Pick from drop-down list gives empty or erroneous result 6
Colour-coding a cell from a drop down list 1
Prevent duplicate entries within a range of cells from a drop-down 3
Drop down list with pricing 1
Drop down list - link to another worksheet 4
run code *after* drop down list choice 2
Cell Referencing too and from check boxes? 0
Drop down list 3

Back
Top