LO 6, OS Mojave
Hi all, I want to use Find and Replace to amend formulae in a given column, however I don’t know how to select all formulae of a certain type in a particular column in the Find & Replace dialog, only specific formulae pertaining to just 1 cell.
E.g. Say I have a sheet with two columns (A and B) and three rows, and there is a formula in all three rows of column B that equals the adjacent number in cell A minus 1 ["=A1-1", “=A2-1” and “=A3-1”], how do I specify, when searching for the formula to replace in the Find & Replace dialog, that I want to find & replace ALL formulae of the “column A minus 1” variety in column B, rather than just 1 instance of this formula? What would the formula search in the Find & Replace dialog look like in this instance?