contains string

Hi, I have a list of Zip Codes, and a list of 3 first digits to look for in the zip code. I'm having a hard time writing the formula to achieve it. Please see the attached image as an example of what I'm looking for. Thanks!

Hi, I need to look at a range of values that consist of customer name, item # & colors available. I need to know if a specific combination exists in the list. I am using a countifs statement to accomplish this, but I can't figure out the color part. I can't search a range of values to see if a...

Example data set: Artwork. Each row represents one artwork. One column represents the colors found in that piece. Colors are not mutually exclusive, so this column would look something like (R=red,O=orange,Y=yellow,G=green,B=blue,P=purple,0=black,1=white): R01 RYG1 GB Y P01 ROYGB01 Can I make...

Hi ! This is what I need to do: I have a range (lista) that contains strings in column 2, and I want to filter it by those cells that contain any of the words in a string called myarray. Being myarray for example {"one","two","three"}, i would need to filter lista by the cells that contain...

When you filter a spreadsheet, you can find results that are similar to a condition. I have families of products that share a common 3 digits, but the rest of the model number is different. The 3 similar digits could be the first 3 digits, or it could be 3 digits starting with the 2nd digit...

Hi, long time listener, first time poster I have two sets of data, as per example below, and trying to figure out the syntax to perform a lookup based on the first two words in a cell (separated by a comma) in the corresponding data, and return a mapped value. Master Data <tbody> <tbody>...

Hi there. I'm extremely new to VBA and MS-Access. I very simply need to have specific folder names on my desktop to appear in a msgbox when a form is loaded. This folder then needs to be copied to another location. The folder name contains the characters "BAC". Thus it could be aaBac2013 or...