Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting and maintaining formula integrity
I have an Excel Sorting question:
I have the following Table: A B C D % Rank Cost Markup 13% 5 1.00 =A2 10% 4 2.00 =A3 5% 6 3.00 =A4 8% 2 4.00 =A5 14% 1 5.00 =A6 12% 3 6.00 =A7 etc.. When I select columns B, C & D and sort by "Rank" in Ascending Order, I lose the integrity of the "Markup" column (column D). The results in columns B & C get sorted properly Except for column D as follows: B C D Rank Cost Markup 1 5.00 13% (=A2) 2 4.00 10% (=A3) 3 6.00 5% (=A4) 4 2.00 8% (=A5) 5 1.00 14% (=A6) 6 3.00 12% (=A7) etc.. What formula can I enter in column D instead of simply entering =A2, =A3, etc..? Thank you. Ed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting multiple columns and maintaining grouping of information | Excel Discussion (Misc queries) | |||
Maintaining formulas when sorting | New Users to Excel | |||
sorting linked columns across worksheets, maintaing row integrity | Excel Discussion (Misc queries) | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |