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