contains

I have a column containing broken/good domains I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]

I'm trying to check each list if any of its content matches any other lists' contents, and then flag them if found e.g. for each List in Time if List.ContainsAny(Current List, Any List from time column) then flag repeat for all...

Hey, I am looking for some guidance on how I might achieve the following: I have a column (column H) of full addresses, for example: 1234 SW 80th Pl, Miami, FL 33331 On another sheet, I have a list of COUNTIES in column A, and CITY in column B. COUNTY CITY Palm Beach Acacia Villas...

Hello, I'm using power query to compile multiple spreadsheets. I have added a custom column which I need to have an If/else statement. If my SITE column contains East and in the same row the NUMBER column contain 1 then enter "East1" This part is working but I have more data to check, else if...

Hi. Pretty sure I've seen VBA code to do this, but is it possible to filter multiple columns within a table using wildcards (e.g., "contains")? Example column headings would be "FathersName", "MothersName","PaternalGrandparentsNames".

Hello All, I've scoured the site, but first post, so hopefully I'm clear in the Q description. I've got a worksheet, A-H, 1-100. In Columns C,D,E, there are singular, non-unique values. In Column G, there's a string of values which may contain one or more of the values from C,D,E. I'm trying...

Hi guys, I've been struggling with this for a few hours, not certain if I'm dumb or not lol. Assume I have a cell with text. I need to check if any of the values within a specified range are inside that cell. Ideally return that value within the range. Example: Cell content = "I have this...

Hello, I'm looking for a way to have a VBA macro to look at a range of cells, determine if the value 'x' appears in the row; if Yes then hide image, if no then show image. So the macro will be on sheet ("Upload Data") - commandbutton1 If worksheets("Prepared File").range("9:9") contains an...

I'm fairly new to VB but I'm trying to write a program that is meant to do the following; XL file#1 Look in column D Copy first value (M123, I use a "mid" function to extract only the numbers.) XL file#2 Custom filter column J (Criteria1:="contains" previous value 123) Copy all visable rows...