Hi,

On my spreadsheet I have a column with ten numbers. The numbers are
errors based on a calculation. What I manually do is look at the
numbers and divide them into 1 2 3 4 or 5 ranges.

E.G.

1 0
2 1.4
3 1.2
4 1
5 1
6 1
7 0.5
8 0.5
9 0.2
10 0


In the above example I would manually make the groupings:

1-3 = 1.4
4-6 = 1
7-8 = 0.5
9-10 = 0.2

and in this case group the errors into 4 groups.

Another example:

1 0
2 0
3 0
4 0
5 0
6 1
7 1
8 1
9 1
10 1

I would make the groupings:

1-5 = 0
6-10 = 1

and in this case group the errors into 2 groups.

And one more example:

1 0.5
2 0.1
3 0.1
4 0.2
5 0.2
6 0.8
7 0.7
8 0.8
9 1
10 1.5

In this example I would group the numbers as such:

1 = 0.5
2-3 = 0.1
4-5 = 0.2
6-9 = 1
10 = 1.5

and in this case group the errors into 5 groups.

Can excel intuitively by formula, make this calculation and grouping
somehow?

Thanks for any advice,

Aaron.