Isolating Columns with specific information

ryan.rb.black

New member
Joined
Jun 27, 2014
Messages
1
Reaction score
0
Points
0
I am currently using Excel to compare a number of different membership options for a client. The are lined up column by column with a selection of amenities down the first column. In each column after the first is a membership option and a tick as to whether or not each amenity is present in each specific membership. What I am hoping to be able to do is search for specific amenities that the client wants, and present him with the options that have these. For example if I were able to type in "swimming pool" that would be able to eliminate all the memberships without a swimming pool. Any help would be massively appreciated.

Cheers.
 
Top