Hi.
I am not an Excel expert, I use it maily as a database whith no macros and so on. I have an Excel sheet where I want to use references from a cell in one row to a cell in another row, for example two rows above (row 13). But when I then sort the table, the references point to a wrong cell. I have tried to use absolute and relative references, and that does not help. With absolute references, the referring cell stays at the same row as it was previously (row 13). With a relative reference, the cell refers to a cell two rows above, but with a different sorting that cell has changed to another row.
What should I do?
Svensson
I am not an Excel expert, I use it maily as a database whith no macros and so on. I have an Excel sheet where I want to use references from a cell in one row to a cell in another row, for example two rows above (row 13). But when I then sort the table, the references point to a wrong cell. I have tried to use absolute and relative references, and that does not help. With absolute references, the referring cell stays at the same row as it was previously (row 13). With a relative reference, the cell refers to a cell two rows above, but with a different sorting that cell has changed to another row.
What should I do?
Svensson
