Minh Hung asks: Hello Mr Oscar I have the matter to create a megaformula to categorize my list. For short […]
Split search value using delimiter and search for each substring
Anil asks: I have A1(anil singh raj) It can be anything Like A1(singh raj anil) I want return value in […]
Multiple wildcard lookups and include or exclude criteria
Dave asks: Hi Oscar, This is great and compliments your Multiple Criteria and Multiple Matches series of posts very well. […]
Search for a text string and return multiple adjacent values
This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]
Search each column for a string each and return multiple records – OR logic
RU asks: Can you please suggest if i want to find out the rows with fixed value in "First Name" […]
Quickly highlight records containing text strings in excel (AND Logic)
This blog post shows you how to highlight rows where text string criteria are found. Example, continents criterion (cell B3) […]
Return multiple matches with wildcard vlookup
Mr.Excel had a "challenge of the month" June/July 2008 about Wildcard VLOOKUP: "The data in column A contains a series […]
Extract records where all criteria match if not empty
Question: I second G's question: can this be done for more than 3? i.e. (Instead of last name, middle, first) […]
Search and display all cells that contain all search strings in excel
Jerome asks, in this blog post Search for multiple text strings in multiple cells in excel : If the list […]
Search for multiple text strings in multiple cells in excel, part 2
Jerome asks, in this blog post Search for multiple text strings in multiple cells in excel : If the list […]
Lookup with multiple criteria and return multiple search results
Question: How do I search a list containing First name column and a last name column? I want to search […]
Search for multiple text strings in multiple cells
Question: How do I search a list for two text strings and return a list with where both strings occurs? […]
How to search for a string in a cell range
Question: How do i create a flexible search formula to search a list? Answer: The following formula let´s you search […]
Welcome! I am 