Hi there, in column A I have a list of words.
I column B I have a formula that will return either a 1 or a 0 based on if the adjacent cell in A is populated.
Somewhere in column A there will be a cell called "END" - is it possible to ensure that any row below the cell containing "END" has a 2 inserted?
I have inserted an example (without the formula)
Bookmarks