Distribute formula

[doriannjeshi]

Hello,
I need a formula that distributes amost evenly as in the first 2 cases

Book15
	A	B	C	D	E	F	G
1	Qty	OP1	OP2	OP3	OP4	OP5	OP5
2	10	2	2	2	2	1	1
3	25	5	4	4	4	4	4
4	18
5	9
6	8
7	26
8	18
9	10
10	1
11	2
12	8
13	14
14	12
15	12
16	10
17	8
18	4
19	15
20	47
21	10
22	25
23	17
24	10
25	4
26	15
27	10
28	6
29	12
30	20
31	30
32	20
33	27
34	15
35	6
36	15
37	10
38	4
39	12
40	25
41	15
42	10
43	5
44	15
45	20
46	25
47	16
48	10
49	6
50	3
51	30
52	22
53	10
54	8
55	20
56	30
57	4
58	3
59	8
60	13
61	12
62	10
63	7
64	5
65	4
66	10
67	25
68	20
69	7
70	2
71	2
72	4
73	15
74	30
75	25
76	20
77	12
78	6
79	4
80	2
81	1
82	13
83	27
84	17
85	5
86	10
87	30
88	17
89	5
90	3
91	8
92	13
93	12
94	10
95	7
96	5
97	4
98	2
99	2
100	2
101	2
102	4
103	4
104	4
105	4
106	3
107	2
108	2
109	2
110	2
111	2
112	20
113	30
114	12
115	15
116	27
117	20
118	13
119	35
120	25
121	7
122	10
123	30
124	17
125	5
126	4
127	10
128	16
129	16
130	14
131	2
132	6
133	12
134	8
135	4
136	8
137	12
138	16
139	22
140	24
141	18
142	12
143	6
144	2
145	1
146	25
147	50
148	40
149	15
150	5
151	20
152	30
153	7
154	2
155	8
156	16
157	14
158	10
159	6
160	4
161	2
162	15
163	25
164	20
165	10
166	2
167	8
168	14
169	16
170	12
171	6
172	4
173	62
174	2
175	8
176	14
177	16
178	12
179	6
180	4
181	15
182	25
183	20
184	5
185	4
186	8
187	12
188	14
189	14
190	10
191	8
192	4
193	2
194	1
195	15
196	27
197	15
198	5
199	8
200	27
201	20
202	7
203	30
204	15
205	35
206	20
207	10
208	17
209	45
210	2
211	4
212	8
213	12
214	14
215	10
216	6
217	4
218	2
219	1
220	20
221	45
222	35
223	20
224	8
225	20
226	24
227	10
228	15
229	27
230	15
231	5
232	15
233	35
234	28
235	15
236	15
237	27
238	15
239	5
240	15
241	27
242	15
243	5
244	10
245	30
246	17
247	5
248	2
249	8
250	16
251	14
252	10
253	6
254	4
255	2
256	25
257	33
258	4
259	10
260	25
261	17
262	10
263	2
264	8
265	14
266	16
267	12
268	6
269	4
270	10
271	25
272	18
273	9
274	8
275	14
276	3
277	2
278	8
279	14
280	16
281	12
282	6
283	4
284	15
285	32
286	15
287	15
288	35
289	20
290	10
291	17
292	45
293	15
294	30
295	20
296	10
297	6
298	12
299	8
300	4
301	10
302	27
303	18
304	7
305	2
306	8
307	14
308	10
309	13
310	8
311	4
312	3
313	2
314	2
315	8
316	16
317	12
318	14
319	8
320	6
321	4
322	10
323	35
324	20
325	4
326	10
327	25
328	15
329	6
330	10
331	25
332	30
333	15
334	8
335	15
336	10
Sheet1

 

[doriannjeshi]

to be more clear, the quantity of column a should be distributed wholy in the other columns row by row as the first two examples

 

[dalvin647]

Hi doriannjeshi,

This formula only works if columns only go to G as picture above and there's 6 spaces to distribute through.

Paste the following formula into Cell B2, and then drag to all other blank cells.

=ROUNDDOWN($A2/6,0)+IF(($A2-FLOOR($A2,6))>=(COLUMN()-1),1,0)

Good luck.

Thanks

 

[doriannjeshi]

Thank you @dalvin647