Duplicate records
Excel » Duplicate records »
This article describes how to filter duplicate rows with the use of a formula. It is, in fact, an array […]
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
Extract unique distinct records from two data sets
Filter unique distinct records using criteria
Filter unique distinct records
Excel » Duplicate records »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup