Frequency Function question

[kalhoun]

I'm attempting to use the frequency function but seem to be getting the wrong
solutions.
Th formula is thus: in c2:c5 =Frequency(a2:a17,b2:b5)

It looks to me like the formula is fouling.

data Bin freq Fnctn
1 3 6
1 5 9
2 7 12
2 10 13
3
3
4
4
5
5
6
6
7
7
8
8

 

[vezerid]

Hi,

This is because you did not enter it as an array formula. To do it
properly, select cells C2:C5, enter the formula and then commit with
Ctrl+Shift+Enter (CSE). It will give very different (correct) results.
When testing your data w/o CSE I get exactly the same values, which of
course are wrong.

HTH
Kostis Vezerides

 

[Domenic]

Try the following...

1) Select cells C2:C6

2) Enter the formula...

=FREQUENCY(A2:A17,B2:B5)

3) Confirm with CONTROL+SHIFT+ENTER, not just ENTER

Does this return the correct result?

 

[kalhoun]

Very good. Thank you both.

Try the following...

1) Select cells C2:C6

2) Enter the formula...

=FREQUENCY(A2:A17,B2:B5)

3) Confirm with CONTROL+SHIFT+ENTER, not just ENTER

Does this return the correct result?