At 15:51 09/06/2008 +0200, Hans Noname wrote:
Op zondag 08 juni 2008 schreef Brian Barker aan [email protected]:
Depending on exactly how your spreadsheet is constructed, the
solution may be to freeze the values of the formulae in columns O
and P before you do the sort. To achieve this, select and copy
the block of values in those columns (NX to PQ). Then paste them
back into the same place, but using Edit | Paste Special...
These data are constantly changing, so this procedure would become
rather annoying quite quickly. But I'll certainly keep this hint in
mind in case I need it some time.
I realised after I sent my last suggestion that there is a better
solution, which will almost certainly apply to your case. My
apologies for not thinking of this earlier. In fact, you don't need
to freeze the values in columns O and P to create the effect that you
need, but just to modify the formulae.
If we imagine - as I suggested before - a simple case in which the
cells in column O are simply a copy of what is in another column, say
column K, then the formulae in column O would be something like =K5,
=K6, and so on. The problem - as we identified before - is that when
these formulae are moved in the sorting process, they are modified in
the usual spreadsheet fashion. The result is that although the moved
formulae are changed, what ends up in each cell is exactly what was
there before. To prevent this, all you have to do is to prevent this
automatic change of row number. In the example above, the formulae
need to be =K$5, =K$6, etc. When these new formulae are moved by the
sort, the row numbers are not changed, so that the cells they refer
to and the consequent values displayed are genuinely sorted.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
