Select numbers between two numbers...

[Darin Kramer]

Hi guys,

Got a list of 50 numbers from 1 to 1000

Want to stratify into different groups... ie 1 to 50, and then 50 to
100, etc... formulae possible to do so...?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Markus Scheible]

Hi Darin,

Want to stratify into different groups... ie 1 to 50, and then 50 to
100, etc... formulae possible to do so...?

Try

Int(number/50)

This gives you back numbers from 0 to 20 with the
following system:

if number < 50 then 0
if 50 < number < 100 then 1
if 100 < number < 150 then 2

and so on.

You could use this number to fill the numbers into
different data arrays...

Best

Markus

 

[Darin Kramer]

Hi Mark,

The int function rounds down to the nearest integer... dont quite
understand how that will assist in finding my numbers....?
eg
a1 1
a2 20
a3 25
a4 28
a5 32
a6 34

So if I ask for numbers between 20 and 30 I need a response of 3.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

=countif(A1:A6,">=20")-Countif(A1:A6,">30")

 

[Ron Rosenfeld]

Hi guys,

Got a list of 50 numbers from 1 to 1000

Want to stratify into different groups... ie 1 to 50, and then 50 to
100, etc... formulae possible to do so...?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

It's not clear what kind of output you want, but have a look at FREQUENCY and
HISTOGRAM functions.


--ron