How do I choose multiple items from a drop down box?
 

I have created a list of items to choose from in a drop down box. I would
like the user to be able to choose multiple items.

How do I choose multiple items from a drop down box?
 

If it's a data validation dropdown list, you can do that with
programming. There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'


Lisa Pearl wrote:
I have created a list of items to choose from in a drop down box. I would
like the user to be able to choose multiple items.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

How do I choose multiple items from a drop down box?
 

Try this:

With your list in A1:A31

E1: Self-Sufficient
F1:
=COUNT(1/FREQUENCY(IF($C$2:$C$31="",IF($A$2:$A$31<"",MATCH ($A$2:$A$31,$A$2:$A$31,0))),ROW($A$2:$A$31)-ROW($A$2)+1))

E2: Dependent
F2:
=COUNT(1/FREQUENCY(IF($C$2:$C$31<"",IF($A$2:$A$31<"",MATC H($A$2:$A$31,$A$2:$A$31,0))),ROW($A$2:$A$31)-ROW($A$2)+1))

Using your posted data, the formulas return:
Self-Sufficient: 13
Dependent: 12

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lisa Pearl" wrote:

I have created a list of items to choose from in a drop down box. I would
like the user to be able to choose multiple items.

How do I choose multiple items from a drop down box?
 

OK....this surely went to the wrong post!

I'm having another hardware problem....
There's a loose nut in front of my computer. : \

**********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

With your list in A1:A31

E1: Self-Sufficient
F1:
=COUNT(1/FREQUENCY(IF($C$2:$C$31="",IF($A$2:$A$31<"",MATCH ($A$2:$A$31,$A$2:$A$31,0))),ROW($A$2:$A$31)-ROW($A$2)+1))

E2: Dependent
F2:
=COUNT(1/FREQUENCY(IF($C$2:$C$31<"",IF($A$2:$A$31<"",MATC H($A$2:$A$31,$A$2:$A$31,0))),ROW($A$2:$A$31)-ROW($A$2)+1))

Using your posted data, the formulas return:
Self-Sufficient: 13
Dependent: 12

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lisa Pearl" wrote:

I have created a list of items to choose from in a drop down box. I would
like the user to be able to choose multiple items.