I am trying to do calculations in a spreadsheet so that the cells are calculated in order; across a row, then down to the next row; across that row, down to the next and so on. In doing so I am using conditional statements to pick up text from a separate column of cells filled with text that I want to use. How do you get Excel to do this?
This leads to a second question. Not all cells will have text put in them. Conditional statements decide when to pick up text and put it in a cell. How do I track which cell I am up to in the column so that next time my conditional statement says go and get some text, I get text from the next cell which has not already had its content used?
This leads to a second question. Not all cells will have text put in them. Conditional statements decide when to pick up text and put it in a cell. How do I track which cell I am up to in the column so that next time my conditional statement says go and get some text, I get text from the next cell which has not already had its content used?