Repeat a number X amount of times

[jennyyy]

Okay so I have two tables:


Count
Jan Feb Mar April May June July
0 0 1 0 0 0 0

Revenue
Jan Feb Mar April May June July
0 0 25 25 25 25 0


How do I make it so it repeats the 25 X amount of times starting from the count?

Currently X=4 but this may change.

 

[jtakw]

Hi,

You're not very descriptive regarding your data.

So, assuming your "Count" Table is prepopulated as shown:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		Count								Count	Amount
2		Jan	Feb	Mar	Apr	May	Jun	Jul		4	25
3		0	0	1	0	0	0	0
4
5
6		Revenue
7		Jan	Feb	Mar	Apr	May	Jun	Jul
8		0	0	25	25	25	25	0
Sheet511

Cell Formulas
Range	Formula
B8	=IF(OR(COUNTIF($B3:B3,1)=0,COUNTIF($A8:A8,$K2)>=$J2),0,$K2)

Formula copied across.