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)}
Detlef,
Sorry if this is a duplicate post - I replied earlier but I don't think it sent.
The Frequency Formula provided does not work for me. I keep getting the number 3 all of the way down the column when I copy the formula. I did remember to use the array formula.
Any ideas as to what I am doing wrong?