regexgoogle-sheetsgoogle-sheets-formulags-conditional-formattingtextjoin
Highlight duplicate including partial text matching in Google Sheets
I have two sheets on a Google Sheet workbook as shown in the image. I need to highlight values from Column A of Sheet 1 when there is a match in Column A of Sheet 2. I use the conditional format rule =countif(indirect("Sheet2!A1:A"),A1) and things work fine.
But my requirement is also to show partial match in Sheet 1, e.g. if Sheet 1 has another row with "bikram sahu", it also should be highlighted. I tried wildcard characters(*), but that does not seem to work. I appreciate if someone can guide me on this.
Solution
=REGEXMATCH(LOWER(A1), LOWER(TEXTJOIN("|", 1, INDIRECT("Sheet2!A1:A"))))
- Regex for matching a certain number of words
- How to convert "camelCase" to "Camel Case"?
- Negative Lookahead not working in perl regex
- How can I get Vim to highlight non-ASCII characters?
- Regex: Match specific characters in any order without more occurrences of each character than specified
- How to parse names and percents
- PowerShell multiline regex is matching on regex101.com AND regexr.com, but not in Powershell code
- How to get second material name from product description
- How to find second match in sql
- Substitute a regex pattern using awk
- Custom String statement to mathematical operation [PYTHON]
- Regex to match up to 9 num. chars followed by 'ml' and those 9 num. chars don't fall between 1900-2199, but not a Quote char followed by 2 num. digit
- Python re.sub: ignore backreferences in the replacement string
- python re.sub group: number after \number
- Validating email addresses using regular expression with Razor syntax
- How to replace host part of a URL using javascript regex
- Escaping $ variable interpolation in a multiline match
- Match characters between square brackets but only if text inside brackets follows pattern
- How to combine all the words of a sentence extracted with a regex?
- Using regex in python to parse a string for variables names and values
- How can I detect all symbols on mathematical operators on PHP using regex?
- RegEx for combining "match everything" and "negative lookahead"
- How to validate an Instagram username
- Parse video id and start time from differently formatted youtube URL strings
- Python - regex to grab specific lines from text
- how to escape texts for formatting in python
- Regex not correctly rejecting invalid music note values
- regex - error with result - too many occurence
- Parse a formatted, single-line string into an array of associative arrays with predefined column names
- How to split a string by any of multiple delimiters?