I have a column of data (Column A) that has multiple values per row that are delimited by a comma. I’m trying to find a way to search this column to find rows that have two or more codes from another column, Column B (single values in this column). Any ideas on how I can do this? My second question, which is more difficult if even possible, is to do a search of Column A to find rows that contain at least one value from Column B and at least one value from Column C. Any thoughts on this?
Image below:
Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting
Image below:
Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting