Sorting not getting what I want
Hi I have got a worksheet with formulas that use data from other cells.
I now want to sort on one of the columns but leave the results of the
calculations in the cells of the other columns unchanged.
A very simple version looks like this:
A B C
1 w 17 23
2 d =C1 (ie 23) 99
If I now sort on column A, how do I get the following result?
A B C
1 d =C2 99
2 w 17 23
Hope this makes sense.
Thanks
Rod
|