When I sort how do I keep cell references correct?

G

GLS

When I sort a table references to other cells are not maintained properly.

I've tried making them both relative & absolute & either way they no longer
point to the correct cell (which has moved) after the sort is completed.

These are all internal references (within the same table) but on a different
row.
 
W

wjohnson

Select everything below your reference cells and be sure you select al
the columns including the column with with your formula - otherwise th
columns will no longer be in synch
 
G

GLS

Thanks but that doesn't help. I'm selecting all rows in the worksheet.
The cell references to an above or below cell are not maintained.
 
R

rsenn

GLS,

I've stumbled through this before, without a good solution.

Clumsy solutions which I've used and which you may try are to eithe
(a) re-write the formulas to use vlookup or sumif features, or (b) us
helper calculations on another worksheet. When you sort the mai
worksheet, the references to the helper sheet remain correct
 
Top