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 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 » Count unique distinct records »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup