Forum Discussion
How can I create this formula?!
Hi There, Trying to create a formula for this instead of manually typing it every time. If I use the "fill" option, it increases the wrong number. I need the first number to increase and the second n...
You can use the INDIRECT function for this.
Let's say that the first formula is in a cell in row 1. Change it to
=INDIRECT("'CO "&ROW()&"'C17")And if the formula is in (for example) a cell in row 4, it becomes
=INDIRECT("'CO "&ROW()-3&"'C17")