• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

counting unique dates

hey tomas u are right but I have not understood the 1/ thing

If you have date 1.4.2014 in cells A1:A3 and you set up formula countif (a1:a3,a1:a3) in which the second parameter is criteria you get {3,3,3} because criterion in a1 is in cells a1:a3 and that it the case for all cells.

when you pass 1/countif (a1:a3,a1:a3) it delivers {0.33,0.33,0.33}

now when you apply sum function around sum(1/countif (a1:a3,a1:a3)) it delivers 1 which is actually a good result because you have only one unique value in range a1:a3
 
Back
Top