View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kalhoun kalhoun is offline
external usenet poster
 
Posts: 2
Default Frequency Function question

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