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
|