G Guest Sep 22, 2006 #1 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.
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.
D Debra Dalgleish Sep 22, 2006 #2 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'
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'
G Guest Sep 22, 2006 #3 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
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
G Guest Sep 22, 2006 #4 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
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
