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 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
This article describes how to filter duplicate rows with the use of a formula. It is, in fact, an array […]
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup