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 criteria
Create a list of duplicates where adjacent cell value meets a condition
Vlookup and return multiple values
Search and return multiple values
Distribute values across numerical ranges
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 » Duplicate records »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup