Excel (.xlsx) - Drop-down lists/tables - Include specific values/text in drop-down list selection

0

Say I have a column, "Names", of single and multiple names (where two can occupy once cell), e.g.

Names

Anna

Bruce

Charlie

Bruce / Charlie

Anna / Bruce

Upon creating a table I am given a drop-down list of each individual option, but selecting only "Anna", for instance, won't also bring up "Anna / Bruce".

I am unfamiliar with Excel, but my question is:

How do I do it so that when I select "Anna", all cells that have "Anna" in them, e.g. including "Anna / Bruce", will also appear.

Andrew Cina

Posted 2016-03-29T14:47:03.807

Reputation: 5

Answers

1

You can choose to use a Text Filter that Contains "Anna".

enter image description here

You can type "Anna" in the Contains field to show only cells that have "Anna" somewhere in the cell.

enter image description here

This will return cells like "Anna/Bruce", "Andrew/Anna", ect.

enter image description here

The selections that are available with check boxes are limited to the unique cells found in the column. Custom choices cannot be added here, relaying us to use a Text Filter instead.

root

Posted 2016-03-29T14:47:03.807

Reputation: 2 992

Is there a way so that selecting "Anna" in the main drop down will have a similar (and thus expedient) result? – Andrew Cina – 2016-03-29T14:59:13.787

The selections with the check boxes represent each unique cell in the column. You cannot add a custom "where-cell-contains-Anna" selection with a check box to this list. – root – 2016-03-29T15:00:39.017

@AndrewCina, To answer your comment, the check boxes should not be used in case you desire to use the Contains functionality - which is what you are looking for – Prasanna – 2016-03-31T02:03:16.337

Asked: 2016-03-29T14:47:03.807

Viewed: 408 times

Active: 2017-04-08T10:33:56.407