Dropdown list with a group.

[willoughby]

Hi All

Been a while but I'm stumped. I have a large list of data with a dropdown list that filters out what I need. Only issue is I would like to group a few options preferable using one list.

My Example List

Apple
Banana
Orange
Cat
Dog
Mouse
Fruit
Animal

Trick I would like to know how to do is when I select 'Fruit' from the drop down I get the results from Apple,Banana & Orange. Much the same with 'Animal' Happy to add an additional column to the data. Any ideas?

Regards

Willoughby

 

[FormR]

Hi, the link below may help you get started.

https://www.contextures.com/xlDataVal02.html

 

[willoughby]

Hi, the link below may help you get started.

https://www.contextures.com/xlDataVal02.html

Thanks, but not sure I follow. Are you saying that I need to Create Dependent Drop Down Lists?
That I know how to do but figured there must be a way to select one item from one list and get the filter to return values based on a group.

My initial thoughts were to add an extra 'flag' col to the data but was wondering if there a more elegant way.

Kev

 

[FormR]

Hi, you might need to explain a little bit more about what exactly this dropdown box is and how you are currently using it to apply filters, and for the groups, how you know which subset of items belong to each group.

My initial thoughts were to add an extra 'flag' col to the data but was wondering if there a more elegant way.

Without knowing any of the details - this sounds like a sensible and reasonable approach.

 

[willoughby]

Again think lost in translation.

For clarification, Dropdown list is

• Data tab, click Data Validation.
• On the Settings tab, in the Allow box, click List.
  
  Items on List
  Apple
  Banana
  Orange
  Cat
  Dog
  Mouse
  Fruit
  Animal

Example Data

[TABLE="width: 768"]
<tbody>[TR]
[TD][TABLE="width: 21"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 689"]
<tbody>[TR]
[TH]A[/TH]
[TH]B[/TH]
[/TR]
[TR]
[TD]Thing[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]321[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]321[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]543[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]535[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD] 347[/TD]
[/TR]
[TR]
[TD]Mouse[/TD]
[TD]535[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

If 'Cat' selected from the drop-down list. Then I expect to see one line.

[TABLE="width: 689"]
<tbody>[TR]
[TD]Cat[/TD]
[TD]535[/TD]
[/TR]
</tbody>[/TABLE]

If 'Animal' is selected I expect to see three lines.

[TABLE="width: 689"]
<tbody>[TR]
[TD]Cat[/TD]
[TD]535[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]347[/TD]
[/TR]
[TR]
[TD]Mouse[/TD]
[TD]535[/TD]
[/TR]
</tbody>[/TABLE]

I got it working by adding a flag to the data but as above would be nice to know if there was a better way.

W

 

[FormR]

I got it working by adding a flag to the data but as above would be nice to know if there was a better way.

Hi, it's difficult to say, your post still lacks detail.

If 'Cat' selected from the drop-down list. Then I expect to see one line.

[TABLE="width: 689"]
<tbody>[TR]
[TD]Cat[/TD]
[TD]535[/TD]
[/TR]
</tbody>[/TABLE]

Where do you expect to see that one line - what method are you using to show it?

If 'Animal' is selected I expect to see three lines.

[TABLE="width: 689"]
<tbody>[TR]
[TD]Cat[/TD]
[TD]535[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]347[/TD]
[/TR]
[TR]
[TD]Mouse[/TD]
[TD]535[/TD]
[/TR]
</tbody>[/TABLE]

How do we know that cat, dog, and mouse are the "Animals"?