Count unique distinct records
Excel » Count unique distinct records »
The image above shows a table with 3 columns containing random data. It is quite complicated trying to manually count […]
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 » Count unique distinct records »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup