Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a drop down list include multiple cells? | Excel Discussion (Misc queries) | |||
Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
How to allow multiple selection capability in excel drop down lis. | Excel Discussion (Misc queries) | |||
Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
How to choose multiple itmes from a Pivot Table Page drop down men | Excel Discussion (Misc queries) |