Excel Calculation - Help Required.

[Sarravana Kumar]

Example:

Column / Row Sample Values
A2 A
A3 B
A4 C
A5 D
A6 E
A7 F
A8 G
A9 H
A10 I
A11 J
A12 K
A13 L
A14 M
A15 N

There are 14 values, and I need the equal split to 5 values.

--> 14/5 = 280% (% should total 280% and the balance should be carry forwarded)

Result should be:
Result 1: (100%) of A + (100%) of B + (80%) of C
Result 2: (20%) of C + (100%) of D + (100%) of E + (60%) of F
Result 3: (40%) of F + (100%) of G + (100%) of H + (40%) of I
Result 4: (60%) of I + (100%) of J + (100%) of K + (20%) of L
Result 5: (80%) of L + (100%) of M + (100%) of N

 

[AliGW]

Your sample values are letters - this is not really very representative. Try attaching a sample workbook with realistic sample data and manually worked examples.

 

[Sarravana Kumar]

Thanks a lot for looking into it. PFA.

 

[AliGW]

PFA?

 

[AlanSidman]

Please Find Attached?

 

[AliGW]

Ah! Thanks, Alan.

 

[John Jairo V]

Hi, to all!

Check file, with an option. Blessings!

 

[Sarravana Kumar]

Hi John, Thanks a ton, this works like magic, considering I am a novice, kindly request your help in advising on how this calculation works pls.