Excel iterate over table and list output with spilling formula
Hi, i am looking for a formula that iterates byrow and presents the differences between the months like the output below. I am not fully sure how to tackle the problem with a spilling formula. Somebody any suggestions how to approach (especially the reference to the previous value and the way you should iterate the table (with map or a combination byrow / bycol).
thanks in advance,
Michiel
Hi, i am looking for a formula that iterates byrow and presents the differences between the months like the output below. I am not fully sure how to tackle the problem with a spilling formula. Somebody any suggestions how to approach (especially the reference to the previous value and the way you should iterate the table (with map or a combination byrow / bycol). thanks in advance, Michiel Read More