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 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
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