How do I filter a cell with multiple values using only just 1 value?

Question

I have a column with multiple values in a single cell; I want to filter them using just one value so any cells with that matching value will show up (instead of an exact match). How do I do that?

And how do I get the hyperlinks in the spilled cells to work?

Answer 1

I have a column with multiple values in a single cell; I want to filter them using just one value so any cells with that matching value will show up (instead of an exact match). How do I do that?

And how do I get the hyperlinks in the spilled cells to work?

Excel is not really happy working with "multiple values" in a single cell. 

Ideally that column should be split so it only has 1 value. 

So Row 9 would be split into 6 rows.

You have already defined the data as an Excel table, so it is trivial to add the slicer(s) and to teach people how to use the slicers.

.

Then you could make the selections using "Slicers" on the 3 columns.

Some example data, no slicer applied

 

Slicers filtering matching the criteria you used:

There is no problem with the hyperlink, because nothing is being moved, the 'result' is just the source table filtered to show just the result row(s).

In this example, I just filtered for Book and Skill, result shows they have to read 3 chapters , all in the same file

Note that I've turned off the "Filter" buttons in the column headings.

Answer 2

Hi,

Thank you for querying in the forum.

May I know if you want to find the cells which contain only number 1 or all the cells having number 1 and also having other values from column C?

For the second question, if it's convenient, you may also share the sample file here so that we can better understand the situation and help you look into the issue.

You may upload the file to your OneDrive and then share a guest link(no sign in required) here.

Thanks for your patience and understanding.

Best Regards,

Tina

Answer 3

Hi,

Feel free to post back and share the requested information when you have time.

Thanks,

Tina

Answer 4

I want to find cells that contain number and also having other values from Column C.

any other way to share my file with you so you can take a look? My onedrive blocks access from outside my organisation

Answer 5

Hi

Please, follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany