Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to group data?
Hi Ki,
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. If your number is in cell A1: =INT(A1/20+0.5)*20 Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group and Count Text Data More Efficiently | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Pivot table/chart - can I use data ranges? why will it not group d | Charts and Charting in Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |