I am trying to copy a formula down a column. I have done it for years and
worked fine. This time, the first result appears in each cell, but if you
look at the formula in copied cells, they show the correct formula has
changed as I dragged it down the column.
So, the formula changes as I drag, but the answer stays the same as the
The data was sent to me by someone else and I am working with it. I have
even copied just the delivered data to a new spreadsheet and the same result.