Hallo Brian,
Op zondag 08 juni 2008 schreef Brian Barker aan [email protected]:
>> But colO en colP stay the way they were, only colN gets sorted
>> to the correct order.
>> What am I doing wrong?
BB> I think your problem is that the cells columns O and P contain
BB> not values but formulae. When you sort cell ranges containing
BB> formulae, it is these formulae that are moved about - according
BB> to their current values, of course - and they are modified as
BB> they are moved in the same way that they would be if you copied
BB> or filled them into new cells.
I'm afraid that you think correct :( It just did not occur to
me that the formulae would be sorted, not the data that I see.
BB> The values that you will then
BB> see displayed in the cells are the results of the moved and
BB> modified formulae, which may or may not be the values that were
BB> displayed before those formulae were moved.
BB> For example, if the values in column O were just a copy of the
BB> corresponding columns in another column - say, column K - then
BB> the actual contents of column O might be formulae reading =K5,
BB> =K6, etc. If you sort these formulae, they will all be both
BB> moved and modified, but the end result will be the same formulae
BB> in the same places - and exactly the same values in the cells of
BB> column O.
BB> Depending on exactly how your spreadsheet is constructed, the
BB> solution may be to freeze the values of the formulae in columns
BB> O and P before you do the sort. To achieve this, select and
BB> copy the block of values in those columns (NX to PQ). Then
BB> paste them back into the same place, but using Edit | Paste
BB> Special...
These data are constantly changing, so this procedure would become
rather annoying quite quickly. But I'll certainly keep this hint
in my ind in case I need is some time.
Thank you for tour help.
Groeten,
Hans.
jdh punt beekhuizen bij duinheks punt nl
--- GoldED+/LNX 1.1.5/080603
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
