Generate Cylical Alphabetical Sequences

[Cubist]

Similar to this thread, but with additional conditions that the elements are alphabets and a chosen starting character.

Given:
1) the length of the array
2) number of elements in each cycle
3) the starting character.

In the case that it runs out of the alphabet, it should loop back at "A". See the expected output in D below.

Book1
	A	B	C	D	E
1	Length	21		Y
2	Num of element in each cycle	3		Z
3	Starting Letter	Y		A
4				Y
5				Z
6				A
7				Y
8				Z
9				A
10				Y
11				Z
12				A
13				Y
14				Z
15				A
16				Y
17				Z
18				A
19				Y
20				Z
21				A
22
23
Sheet4

 

[Fluff]

How about

=LET(m,MOD(SEQUENCE(B1,,0),B2)+CODE(B3),CHAR(IF(m>90,m-26,m)))

 

[Cubist]

Perfect. Thanks Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.