Distributing the Prime value to secondary value to the subsequent Cells

[abuharvey]

Dear Genius Here I have attached the Mini sheet of my requirement

I need Formula for this distribution

Thanks in advance for your valuable time

Asking_Daniel.xlsx
	A	B	C	D	E	F	G
1	Prime Value	Secondary Value	To be Distributed
2	56.00	16.00	16.00	16.00	16.00	8.00
3	40.00	10.00	10.00	10.00	10.00	10.00
4	12.50	5.50	5.50	5.50	1.50
Sheet1

 

[hagia_sofia]

Hello, what version of Excel are you using?

 

[abuharvey]

Hello, what version of Excel are you using?

Office 365

 

[Fluff]

Office 365

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[hagia_sofia]

Many thanks for your reply. Would this work:

=LET(
a,A2:A4,
b,B2:B4,
c,QUOTIENT(+a,+b),
d,MOD(a,b),
e,MAX(c+IF(d=0,0,1)),
f,MAKEARRAY(ROWS(a),e,LAMBDA(x,y,IF(y<=CHOOSEROWS(c,x),CHOOSEROWS(b,x),IF(y=CHOOSEROWS(c+1,x),CHOOSEROWS(d,x),"")))),
IF(f=0,"",f))

 

[abuharvey]

Many thanks for your reply. Would this work:

=LET(
a,A2:A4,
b,B2:B4,
c,QUOTIENT(+a,+b),
d,MOD(a,b),
e,MAX(c+IF(d=0,0,1)),
f,MAKEARRAY(ROWS(a),e,LAMBDA(x,y,IF(y<=CHOOSEROWS(c,x),CHOOSEROWS(b,x),IF(y=CHOOSEROWS(c+1,x),CHOOSEROWS(d,x),"")))),
IF(f=0,"",f))

Mass .... Working in fantastic way , thank you genies ..... Thank you thank you