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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sybil - 19 Jan 2006 18:07 GMT

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?

Reply to this Message

Toppers - 19 Jan 2006 21:01 GMT

Sybil
Source should be of the form "=$j$2:$j$5"

> 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
[quoted text clipped - 7 lines]
>
> What am I doing wrong?

Reply to this Message

L. Howard Kittle - 19 Jan 2006 21:19 GMT

"=(J2-J5)"

change to =($J$2:$J$5)

HTH
Regards,
Howard

>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
[quoted text clipped - 8 lines]
>
> What am I doing wrong?

Reply to this Message