Build a Report by Filtering Multiple Criteria contained in one Column.

Hanna_A25

Hi all. I'm building a report by filtering one column to see if it contains number 1 OR number 2 OR number N. However, the list of numbers that I need to filter is quite long (also the list is in another sheet), therefore is not a good idea to filter this number one by one.

Any ideas?.

Paul Newcome

Are you able to switch the codes in Sheet 1 to a be a multi-select dropdown?

Genevieve P.

Hi @Hanna_A25

From what I can see, it looks like they're unique numbers without a common theme, which would mean that you would need to individually add it to the filter criteria. Is there anything else on the row that identifies if it's the correct number to filter by?

Hanna_A25

Hi. Basically what I need is a formula to obtain all Descriptions from Sheet 1 in a single cell (divided by a ",") of each of the entry codes that are contained in the column "Codes" (separated by ","). Hopes this diagram explains better :). Thanks a lot.

Paul Newcome

Are you able to switch the codes in Sheet 1 to a be a multi-select dropdown?