This is a question from How to count unique distinct records in a date range
Question: Is there anyway to do this based on date and another criteria? Say if C had dollar values and you wanted to only find uniques that were between a certain $ value and a certain date?
Array formula in B35:
What is named ranges?
How to implement excel array formula to your excel sheet
Change named ranges.
Download excel sample file for this tutorial.
Count unique distinct records in a date range and a numeric range.xls
(Excel 97-2003 Workbook *.xls)
Functions in this tutorial:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than Bins_array.
Adds all the numbers in a range of cells
MATCH(lookup_value;lookup_array; [match_type] Returns the relative position of an item in an array that matches a specified value
ROWS(array) returns the number of rows in a reference or an array
This blog article is one out of twelve articles on the same subject "count unique and unique distinct".
- Count unique values in a column in excel
- Count unique distinct values in two columns in excel
- Count unique distinct values in three columns combined in excel
- Count unique and unique distinct values in a multicolumn range in excel
- Count unique values and unique distinct values in two ranges combined
- Count unique values and unique distinct values in three ranges combined in excel
- How to count unique combined column values
- How to count unique distinct records in a date range
- Count unique distinct records in a date range and a numeric range in excel
- Count unique distinct values in two columns with date criteria in excel
- Count unique distinct months in excel
- Count duplicate distinct values in a column in excel