I have a maths teacher who tells me:
He has a spreadsheet with formulas. Within one of the formulas there is a cell reference to another cell in the same row.
After doing some filtering on the spreadsheet he realises that the cell reference in the formula has changed to another cell in a different row, thus returning the wrong result.
I can't replicate this problem. Has anybody come across this before and do you know what causes it?
Thanks a lot,