How do I create a filter that will recognize multiple check boxes in a column?

Hi, My name is Barb and I'm new to the forum.

I work with multiple spreadsheets that have large criteria groups, for example, counties within a state. Currently, every county has its own column and it's very cumbersome.

I want to rework these spreadsheets to have one column for these counties with a cell for each row that contains multiple check boxes. Each spreadsheet will have 2 columns that need these cells but I will also need to be able to filter one or both of the columns for people searching for a specific criteria.

Is it possible to create filters that will recognize multiple values in a column of cells? Can i also create a secondary filter for a second like column?

The cells would all contain the same information with check boxes that are selected and not selected. This will save over 30 columns and make the spreadsheet much more user friendly.

Thank you for any ideas.

Barb

New to come soon..
Excel's NEW Checkboxes Are Incredibly Cool! Here's why