Forum Discussion
Help: Formula to count no repeat values between dates
Hi! I would like to know a formula to count no repeat values between dates. I mean if we got a column with values and another one with dates (find an example attached) I would like to know how many o...
The above formula will give you the number of the unique dates. However, if you want to the Unique and Duplicates date, kindly follow the steps
1. Select the date range B2:B9
2. Conditional Formatting
3. Highlight cells rule
4. Duplicates values
1. Select the date range B2:B9
2. Conditional Formatting
3. Highlight cells rule
4. Duplicates values
Abiola1 Thanks!
That is the formula that I wanted
{=SUMA(SI((B2:B9>=E1)*(B2:B9<=E2);SI(CONTAR.SI.CONJUNTO(B2:B9;">="&E1;B2:B9;"<="&E2;A2:A9;A2:A9)=1;1;0);0))}
- Alright..
Regards