View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek Aladin Akyurek is offline
external usenet poster
 
Posts: 52
Default 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
...