Need Formula to make Series of Numbers with Defined Conditions

**A1256** · 08-07-2022, 11:47 AM

Hi Everyone,
I hope you are fine,
Series 1
In cell B4, I have value from which the sequence should start. In cell C4, I have value on which sequence will end. In cell D4, I have a value for which next value of sequence will increase. In cell B8, I have a value say 30. This sequence should repeat for 30 times. I want to start this series from cell B10 onward.

Series 2
In cell B5, I have value from which the sequence should start. In cell C5, I have value on which sequence will end. In cell D5, I have a value for which next value of sequence will increase. In cell C8, I have a value say 10. Every next number of the sequence should be repeated for 10 times. I want to start this series from cell C10 onward.

Series 3
In cell B6, I have value from which the sequence should start. In cell C6, I have value on which sequence will end. In cell D6, I have a value for which next value of sequence will increase. In cell D8, I have a value say 10. Every next number of the sequence should be repeated for 10 times. I want to start this series from cell D10 onward.

Please see attached sample file for more clarification

**Limor_OP** · 08-07-2022, 04:13 PM

hi,
Are you using MS365?

**A1256** · 08-07-2022, 08:22 PM

Hi belinda200,

I am using Excel 2021.

**52779** · 08-07-2022, 09:13 PM

Hi,
see attached file..

Series 1

=D4*(MOD((SEQUENCE(F4*B8*E4)-1),E4)+1)

Series 2

=D5*(MOD(INT((SEQUENCE(F5*C8*E5)-1)/C8),E5)+1)

Series 3

=D6*(MOD(INT((C-1)/D8),E6)+1)

Nota :
D8 = 60 (not 10)
and for 300 rows total, Nb repeat
Series 1 F6 = 1
Series 2 F7 = 5
Series 3 F8 = 1

Edit :
=SEQUENCE(F6*D8*E6) or SEQUENCE(F4*B8*E4) or SEQUENCE(F5*C8*E5) = SEQUENCE(300)