Wildcard Search
Excel » Search and return multiple values » Wildcard Search »
How to search for a string in a column
Question: How do i create a flexible search formula to search a list? Answer: The following formula let´s you search […]
Count cells based on background color programmatically
Count Conditionally Formatted cells
Find date range based on a date
Filter duplicate values using critera
Create a list of duplicates where adjacent cell value meets a condition
Vlookup and return multiple values
Search and return multiple values
Search values and return value with highest level
Extract unique distinct records from two data sets
Filter unique distinct records using criteria
Filter unique distinct records
Excel » Search and return multiple values » Wildcard Search »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup