Frequency Function
If you can bear calling two more functions, just enter in...
C2:
=INDEX(FREQUENCY($A$2:$A$81,$C$2:$C$6),ROWS($C$2:C 2))
....and copy down.
MzJuanita wrote:
When i enter =FREQUENCY(A2:A81,C2:C6) into cell C2 i'm not getting an array
of answers. I only get the one answer (35). What am i doing wrong
Data BINS Frequency
76 70 35
72 85
88 100
60 115
72 130
68
80
64
...
|