View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ki
 
Posts: n/a
Default How to group data?

Hi.

Example: list of numeric data: 345, 123, 154, 234,.....(milimeters)
When number is between 110 and 130 then it is 120, when between 131 and 150
then it is 140, and so on.
The result should be for the same list: 340, 120, 160, 240,...(milimeters)
It means that I need to group datas in classes of 20 milimeters.

Is there some short way to get it? I tryed something with many, many IFs,
but it is not so simple.
Can anyone help me?
Thanx.

ki