Forum Discussion
Frequency function for counting dates
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_Lewin
I have looked at this contribution to see if would assist me, but it doesn't quite achieve what I would like to do.
I though I had done what I need to when I got the answer "8" (Cell D6 on the Output tab) in the attached file for working days, but realised I hadn't when I reduced the time between the dates. The formula is picking up the unique dates, but not between the specified dates. Can you see what I have done wrong with FREQUENCY please?
First, please always start a new conversation. Do not hijack threads started by other users.
Second, the formula in D6 is an array formula. You have to enter it with CTRL-SHIFT-ENTER instead of just ENTER.
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?
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?
