=FREQUENCY: It doesn't count duplicates?

[danhendo888]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	A	B	C
1	Date of Payment
2	1-Jul		=FREQUENCY(A2:A6,A2:A6)
3	1-Jul		={2;0;2;0;1;0}
4	4-Jul
5	4-Jul
6	2-Jul
Sheet3

​

[/FONT]

C2 is the formula I am using to count the number of times the dates appear in Column A.
C3 is what I see when I hit F9 on C2 while in Edit mode.

Looking at the first two numbers in

={2;0;2;0;1;0}

The 2 is telling us that 1-Jul appears twice
The 0 is not counting the 1-Jul again because it already gave us the 2.
Is this the correct way to interpret the first two numbers?

What is the very last 0 for?
I have five dates but the FREQUENCY formula produces 6 numbers.​

<strike></strike>
​

 

[Aryatect]

Hi,

So Frequency is used for finding the number of entries in a bin array below link would give an example and other details. Bin array ideally would not contain duplicates. If Frequency is used in the way you are using then you are right first entry will tell how many entries are in the same bucket and second will show 0 as it counted it earlier. Frequency always shows 1 more than the bins to account for the value greater than the given bins.

https://support.office.com/en-us/article/frequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9

If you need more info on FREQUENCY refer to Mike "excelisfun" Girvin's video:
https://www.youtube.com/watch?v=uUrI8hoj8BA

 

[Fazza]

for a count of the dates in column A, consider =countif(a:a,a2)