Ask Your Question
0

How do I sort so that formulae are adjusted

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

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
0

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

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

Hello.

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

Stats

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

Seen: 22 times

Last updated: Dec 24 '18