Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does one link data? Sort different columns?
Hi all,
Simple question, but I cannot find the answer within Excel. It may be more of a job for access but I need to do this in Excel. Say I have 2 columns. Names Salary ----- ------ Steve $1400 Joe $3240 John $1623 Sue $2340 How can I sort the names from a-z but still have the salary move with the new sorting arrangement? I guess I'm looking for some kind of linking. Also, I would also need to be able to sort by salary and have the corresponding name move accordingly too. How is this done please? It should work with 2 columns too. Many thanks, Steve. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Data from several colums into a single one and sort | Excel Discussion (Misc queries) | |||
Paste Link then Data Sort | Excel Discussion (Misc queries) | |||
link columns to sort all together | Excel Worksheet Functions | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I link data between columns? | Excel Discussion (Misc queries) |