hurleystylee
New Member
I have data similar to the following:
[pre]
[/pre]
So, I want a unique count WITHIN the date range. Currently I have this formula:
=SUM(1/COUNTIF(Data!$M$2:$M$10,Data!$M$2:$M$10))[/code]
But, I'm obviously not taking into account the date range. Currently, I have to hard-code the range to include the dates I'm looking for.
[pre]
Code:
4/02/2011 abc
4/03/2011 xyz
4/03/2011 abc
4/10/2011 abc
4/11/2011 xyz
4/13/2011 qrs
I want to have static date ranges, use one formula to drag down the 'Unique' column:
[code]Start End Unique
4/01/2011 4/07/2011 2
4/08/2011 4/14/2011 3
So, I want a unique count WITHIN the date range. Currently I have this formula:
=SUM(1/COUNTIF(Data!$M$2:$M$10,Data!$M$2:$M$10))[/code]
But, I'm obviously not taking into account the date range. Currently, I have to hard-code the range to include the dates I'm looking for.