Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency Function question
Hi,
This is because you did not enter it as an array formula. To do it properly, select cells C2:C5, enter the formula and then commit with Ctrl+Shift+Enter (CSE). It will give very different (correct) results. When testing your data w/o CSE I get exactly the same values, which of course are wrong. HTH Kostis Vezerides 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency Function question
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 |
#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 |
Reply |
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) |