Propagation of values in a spreadsheet

Hello,

Can somebody help me on this question ?

I have a series of figures :

X1 and a associated number : 50.000
X2 and a associated number : 30.000
X3 and a associated number : 20.000
X4 and a associated number : 10.000
X5 and a associated number : 5.000
X6 and a associated number : 2.500
X7 and a associated number : 1.000
X8 and a associated number : 500

The sum of X1 + X2 + X3 + X4 +X5 +X6 +X7 +X8 is always 40,
such as 1,2,3,4,5,5,10,10 or 5,5,5,5,5,5,5,5

I would like to propagate in 40 horizontal cells :

- As many 50.000 as I have of X1, for instance 50.000, 50.000, 50.000 if X1 = 3.
- Same for 25.000
- Same for other numbers.

See attached example spreadsheet.

Thanks for your kind help.
Askalian

Put zero in cell C3 and then this formula in C4:

Formula:

=SUM(A$4:A4)

Then copy this down to C11.

Then put this formula in a cell in column D (it doesn't matter which row - I put it in D11 for testing):

Formula:

=IF(COLUMNS($D:D)>40,"",INDEX($B$4:$B$11,MATCH(COLUMNS($D:D)-0.1,$C$3:$C$11)))

Then copy this across to column AQ or beyond. Then you can just change your numbers in column A for a different display.

Hope this helps.

Pete

Originally Posted by Pete_UK

Put zero in cell C3 and then this formula in C4:

Formula:

=SUM(A$4:A4)

Then copy this down to C11.

Then put this formula in a cell in column D (it doesn't matter which row - I put it in D11 for testing):

Formula:

=IF(COLUMNS($D:D)>40,"",INDEX($B$4:$B$11,MATCH(COLUMNS($D:D)-0.1,$C$3:$C$11)))

Then copy this across to column AQ or beyond. Then you can just change your numbers in column A for a different display.

Hope this helps.

Pete

Thanks, Pete, for the quick answer.

For a mysterious reason, I read #NAME? in cells C4 to C11 when I try to follow your explanation.
Did I miss something ?

Thanks again.
Askalian

Well, if you are in Paris you will need to use the French names for those functions. Also, you will probably need to change the commas to semicolons and the fullstop in -0.1 to a comma, as in -0,1.

Hope this helps.

Pete

Originally Posted by Pete_UK

Well, if you are in Paris you will need to use the French names for those functions. Also, you will probably need to change the commas to semicolons and the fullstop in -0.1 to a comma, as in -0,1.

Hope this helps.

Pete

Originally Posted by Pete_UK

Well, if you are in Paris you will need to use the French names for those functions. Also, you will probably need to change the commas to semicolons and the fullstop in -0.1 to a comma, as in -0,1.

Hope this helps.

Pete

Woops. I should have think twice before and not ask.
Thanks so much, Pete. It works perfectly well.

Have a nice day and Thanks again.
Best.
Frederic