Searching for columns including specific criteria.
I have created a spreadsheet with a number of different insurance options. The criteria specifics for each cover is on the Y axis and down each column depending on the insurance package there are ticks in certain boxes so you know what each cover entails. I am looking for a way to search for specific covers by isolating thing that the cover has. For example if I want a cover with dental care, is there a way of search for dental care, and excel will hide all the non-relevant covers. Any help would be massively appreciated.
Send a sample sheet
Not really clear, can you send a sample sheet?
Have you tried "filters"?