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

[Guest]

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]

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

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

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

 

[Guest]

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<>"",MATCH($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

 

[Guest]

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