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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does one link data? Sort different columns?
Hope this gets you started.
1. Select one of the cells in the data. 2. Click Menu Option "DATA" 3. Click "SORT" the rest should be easy "Steve Lim" wrote in message om... 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. |
Reply |
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) |