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


kalhoun wrote:
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