In one of my spreadsheets, I create rows of data, and with a final column that contains a formula with a mixture of relative and absolute cell references (i.e. with a '$'prefix)
This works fine, until I do a sort on the whole datarange against one of the data columns. The relative cells ref's are fine in the new formulae, but the absolute cell ref's have been changed.
I would expect the latter would remain the same?
Am I doing something wrong, or is this the expected behaviour?