Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |