Query regarding Frequency in excel

[Suresh]

I just learned frequency formula in excel. In a website I saw the attached example. As per that value in D3 should be 1 and value in D4 and D5 also should be diffrent but I am getting as 3, 4 and 6.

Value in D2 is correct which returns as 2. I just did control + Shift + Enter after writing formula in D2. For rest I copied and pasted the same formula but it returns wrong values.

Can some one know what is the right procedure here as I feel I am missing something here.

Find the attachment.

 

[Hui]

Select D2 : D5
F2
Ctrl+Shift+Enter

You array entered the formula into one cell and copied it
It has to be array entered into a number of cells

There are a few functions that require this like Linest()

 

[Suresh]

Wow that helps..