How to specify a data cell into a column formula?
I am having trouble writing a simple column formula as I do not know the syntax to specify a specific datapoint/cell within the formula itself. In the past, I have manually entered the value, but am trying to streamline the process using action recorder/scripts.I need to subtract column #1row #5 from every value in column #1 and put the resulting value into column#2. For example, in Excel, the for...