| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Problem with Frequency() formula
Why/how would such a thing occur?
Age today Bins Count Formula under Count: 65 70 1 <<{Frequency($DATA$RANGE,$BIN$RANGE)} 69 65 4 "" 63 60 0 "" 71 1 "" 65 62 Formula is obviously wrong (DATARANGE is formula Datedif(x,y,"y"). TIA, |
|
#2
|
|||
|
|||
|
The result gives you "less than or equal to" from the bin. So its correct.
Try putting the bin in ascending order, and you will get correct expected answers. Mangesh "Jim May" wrote in message news:tsTte.65606$Fv.4401@lakeread01... Why/how would such a thing occur? Age today Bins Count Formula under Count: 65 70 1 <<{Frequency($DATA$RANGE,$BIN$RANGE)} 69 65 4 "" 63 60 0 "" 71 1 "" 65 62 Formula is obviously wrong (DATARANGE is formula Datedif(x,y,"y"). TIA, |
|
#3
|
|||
|
|||
|
Thanks Mangesh,
"Mangesh Yadav" wrote in message ... The result gives you "less than or equal to" from the bin. So its correct. Try putting the bin in ascending order, and you will get correct expected answers. Mangesh "Jim May" wrote in message news:tsTte.65606$Fv.4401@lakeread01... Why/how would such a thing occur? Age today Bins Count Formula under Count: 65 70 1 <<{Frequency($DATA$RANGE,$BIN$RANGE)} 69 65 4 "" 63 60 0 "" 71 1 "" 65 62 Formula is obviously wrong (DATARANGE is formula Datedif(x,y,"y"). TIA, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem writing Excel formulas via ODBC | Excel Worksheet Functions | |||
| Problem writing Excel formulas via ODBC | Excel Discussion (Misc queries) | |||
| formula problem | Excel Discussion (Misc queries) | |||
| Frequency formula | Excel Worksheet Functions | |||
| Need a formula for this problem | Excel Worksheet Functions | |||
Hybrid Mode
