L
Lisa Pearl
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.
like the user to be able to choose multiple items.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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'
programming. There's an example here:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'
R
Ron Coderre
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
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
R
Ron Coderre
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
I'm having another hardware problem....
There's a loose nut in front of my computer. : \
**********
Regards,
Ron
XL2002, WinXP