Hello Excelworld,
I have the following problem:
There is a calculation that will be executed x times.
x will be determined in advance. The column in which the outcome will be posted depends on x.
I need a function that enables me to display the outcome in a fixed cell. For example if x is 2 the outcomes can be found in B3 but when x is 4 it will be in D3.
I know this is possible for rows but i did not succeed in adjusting the INDIRECT function in a way to do the same for columns based on a number.
Anybody knows a solution for that?
Thanks in advance
Jannis
Bookmarks