Ask Your Question

How do I sort so that formulae are adjusted

asked 2018-12-24 18:22:35 +0200

vulpius gravatar image

I am indexing a book entering items in order of appearance, and setting up subtractions to give a column with the lengths of each item. When I sort them into alphabetical order, the item lengths are altered.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-24 19:22:05 +0200

updated 2018-12-24 19:29:11 +0200


Please see this topic about updating cell references while sorting data. Pay attention to @Lupp provided information - there are issues when Update references... are enabled.

You can also copy information needed to new sheet using Paste Special and copying only values, not formulas, so after sorting this new sheet values will be kept unchanged.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-24 18:22:35 +0200

Seen: 23 times

Last updated: Dec 24 '18