Forum Discussion
Solved
Frequency function for counting dates
Hi, I have a column that contains date values rounded with the INT function. My understanding is that these can be counted using the Frequency function but I am not getting the result I expect. ...
John,
=IF(COUNTIFS(A$1:A1,A1)=1,COUNTIFS($A$1:$A$10,A1),0)
Or with FREQUENCY(): Select B1:B10, type in the formula and press CTRL-SHIFT-ENTER.
{=FREQUENCY($A$1:$A$10,$A$1:$A$10)}
John,
=IF(COUNTIFS(A$1:A1,A1)=1,COUNTIFS($A$1:$A$10,A1),0)
Or with FREQUENCY(): Select B1:B10, type in the formula and press CTRL-SHIFT-ENTER.
{=FREQUENCY($A$1:$A$10,$A$1:$A$10)}
Hi Detlef,
I set up everything just as you indicated for the Frequency function, however it is still not working.
I get the value 3 and copying the function to the first cell, copying it down to the other cells not seem to alter the values - still 3.
One of my attempts included wrapping the frequency function in the SUM function and I used the "--" to ensure that true/false values were converted to integer data.
Any idea what I might be doing wrong?