Select numbers between two numbers...
 

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!

Select numbers between two numbers...
 

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

Select numbers between two numbers...
 

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!

Select numbers between two numbers...
 

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

--
Regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...


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!

Select numbers between two numbers...
 

On Thu, 10 Feb 2005 03:38:01 -0800, Darin Kramer
wrote:


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