Forum Discussion

AlbertoBermejo's avatar
AlbertoBermejo
Copper Contributor
Jan 03, 2020

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 of these values don't repeat between particular dates. For example, in the table attached I would like to know how many values are not repeated between 01/01/2020 and 31/01/2020. The answer must be 3 (Excel, Word and Outlook). Could anybody help me with a formula to get that number?

Thanks a lot in advace!!

excel
Formulas and Functions

4 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Jan 03, 2020
    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


    • AlbertoBermejo's avatar
      AlbertoBermejo
      Copper Contributor
      Jan 03, 2020

      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))}