ExcelBanter - Problem with Frequency() formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem with Frequency() formula (https://www.excelbanter.com/excel-worksheet-functions/31677-problem-frequency-formula.html)

Jim May

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,

Mangesh Yadav

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,

Jim May

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,

All times are GMT +1. The time now is 04:59 AM.