Hello everyone!
Is it possible to get a result similar to one shown on the screenshot using the in-built Excel finctions? Or shall I look into VBA macros?
What I am interested to get is the following: let's say I have three rows (or columns - that doesn't matter) of data pieces. Let's say it is (1) A,B,C, then (2) x,y,z, then (3) 1,2,3. I need to iterate through each of them in what is essentially subcycles - first I get A, then add x to A, then 1 to x, then 2 to x, then 3 to x, then I add y to A, then 1 to y, and so on.