Simple task?

[vxs]

Hi All,
I need to complete a task each morning and I don't quite know what the easiest way of doing it is.

Each morning at work ill get a set of figures in an Excel spreadsheet which I need to group together to make groups of 280. Example data:

37
37
67
53
35
33
28
29
48
50
40
35
59
37
44
36
52
36
38
35
51
54
47
31
26
52
26
34
38
50
42
35
50
51
39
32
36
44
41
55
56
42
40
44
64
73
50
51
48
67
72
58
54
57
51
45

So with these figures I need to make groups of as close to 280 as possible. The figure can be lower but not higher if required.

At the moment I just do the maths myself clicking cells in Excel adding them up and marking them a specific colour so I know which ones I have already picked.

But is there a formula, an option or way to do this quicker in Excel?

Any help greatly appreciated.

 

[vxs]

Any idea's people? Sorry to bump so soon but already on page 4 :O this forum moves fast.

 

[JoeMo]

Here's one way to do this. The yellow fill shows the end of a group and is obtained by conditional formatting as follows:
select B2:A57 and use the condition =$C2=""
Copy the formula in B2 all the way down to the end of the data.

Excel Workbook
	A	B	C	D	E
1	Data	Cum		Target	280
2	37	37
3	37	74
4	67	141
5	53	194
6	35	229
7	33	262
8	28
9	29	29
10	48	77
11	50	127
12	40	167
13	35	202
14	59	261
15	37
16	44	44
17	36	80
18	52	132
19	36	168
20	38	206
21	35	241
22	51
23	54	54
24	47	101
25	31	132
26	26	158
27	52	210
28	26	236
29	34	270
30	38
31	50	50
32	42	92
33	35	127
34	50	177
35	51	228
36	39	267
37	32
38	36	36
39	44	80
40	41	121
41	55	176
42	56	232
43	42	274
44	40
45	44	44
46	64	108
47	73	181
48	50	231
49	51
50	48	48
51	67	115
52	72	187
53	58	245
54	54
55	57	57
56	51	108
57	45	153
Sheet6