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

If I assume that there is loads more than 2 rows, this should help.
Make another 2 columns, D and E
D and E correspond to A and C respectively, D1 Formula is =A1,
E1 =C1

Sort columns D and E in ascending order by column D

Make 3 more columns, F, G and H

F formula =D1
G formula =VLOOKUP(D1,A$1:B$10000,2) "This assumes you have 10000
rows"
H formula =E1

Drag every cell in row 1 down to where ever the table ends. The columns
A, B and C that you want are now displayed in columns F, G and H
respectively.


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=475592