Frequency Function question
Very good. Thank you both.
"Domenic" wrote:
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?
In article ,
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
|