Basically, I am trying to use Excel as a contact data base. I have all the typical columns (ie. Name, Address, Phone, etc), but I also have a "Category" Column. I would like to be able to filter this column and my problem is, sometimes the cells in this column have more than one value. For example, one of the categories is "MD", so any contact that is an MD has "MD" in their cell under the "Category" column. However, some MDs are also patients, so in their cell under the category section it would say something like "MD, Patient". When I do this though, it creates a whole separate filter in the drop down menu called "MD, Patient". If I wanted to display ALL patients, for example, how would I filter correctly so that any person that has "patient" somewhere in their cell under my category column is displayed? I should also say that things are not always in the same order. For example, one contact may have "MD, IBP, Patient" under the category column and another may have "Pilates, MD, Patient", etc.
I hope this makes sense, because I'm SO confused!
I hope this makes sense, because I'm SO confused!
