View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Markus Scheible[_2_] Markus Scheible[_2_] is offline
external usenet poster
 
Posts: 95
Default 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