Use an array to iterate through a matrix

[Aoiumi]

I’m new to arrays. Is it possible to use an array to iterate through matrix values? If so, how would this formula be structured?

Below the calculation changes if it aA aB aC aD or aE...bA bB... an so forth.


A B C D E
a
b
c
d
e

[FlameRetired]

Hello Aoiumi. Welcome to the forum.

The simplest way would be to lay out a table of concatenated strings like this with formula in B2 filled down and across

Please Login or Register  to view this content.

	A	B	C	D	E	F
1		A	B	C	D	E
2	a	aA	aB	aC	aD	aE
3	b	bA	bB	bC	bD	bE
4	c	cA	cB	cC	cD	cE
5	d	dA	dB	dC	dD	dE
6	e	eA	eB	eC	eD	eE

Output would be with this formula in A8 and filled down until you get blanks.

Please Login or Register  to view this content.

	A
8	aA
9	aB
10	aC
11	aD
12	aE
13	bA
14	bB
15	bC
16	bD
17	bE
18	cA
19	cB
20	cC
21	cD
22	cE
23	dA
24	dB
25	dC
26	dD
27	dE
28	eA
29	eB
30	eC
31	eD
32	eE
33

---

If you prefer to do it without the table concatenate in formula and enter essentially the same formula in A8. Fill down until you get blanks.

Please Login or Register  to view this content.

While these are array formulas they do not have to be committed with CSE. Just Enter will do.

[Aoiumi]

Thank you so much for the help! I really appreciate it.

[FlameRetired]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.