D
Danny@Kendal
When sorting rows with formulas that refer to other rows
is there a way to make sure these formulas refer to the
referred cell's new location?
eg:
cell B10 formula is "=B1"
after sorting in reverse order,
row 10 becomes row 1
and row 1 becomes row 10
The new formula should now be "=B10"
instead it tries to refer to a negative row value.
Any way to fix this? It's Excel2000 on XPpro.
Google returns "create your formulas after you've sorted the data" which is
not helpful.
I was working on a large index table which has lots of cross-references.
After sorting the table I found most of the references were either broken or
wrong so I had to highlight all the formulas and go through checking them
all. Next time this will all be done automatically and hopefully with a lot
less trouble by Adobe InDesign.
is there a way to make sure these formulas refer to the
referred cell's new location?
eg:
cell B10 formula is "=B1"
after sorting in reverse order,
row 10 becomes row 1
and row 1 becomes row 10
The new formula should now be "=B10"
instead it tries to refer to a negative row value.
Any way to fix this? It's Excel2000 on XPpro.
Google returns "create your formulas after you've sorted the data" which is
not helpful.
I was working on a large index table which has lots of cross-references.
After sorting the table I found most of the references were either broken or
wrong so I had to highlight all the formulas and go through checking them
all. Next time this will all be done automatically and hopefully with a lot
less trouble by Adobe InDesign.