| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average function question | Excel Worksheet Functions | |||
| NOW function question | Excel Worksheet Functions | |||
| Array Function Question | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Frequency function | Excel Discussion (Misc queries) | |||
Threaded Mode
