Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking cells (2)
Can I link two cells so they remained associated.
e.g. Column A has a list of ages in random order. Column B has the respective names of the people. If I do a "LARGE" sort on the ages, can I link the names so that they sort as well? Thank you Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking cells (2)
If you select both columns together and then sort by 'Large' with column A,
Column B will also sort according to how Column A sorts. The Name will stay beside the Age. Mike "Dan Kraemer" wrote in message ... Can I link two cells so they remained associated. e.g. Column A has a list of ages in random order. Column B has the respective names of the people. If I do a "LARGE" sort on the ages, can I link the names so that they sort as well? Thank you Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking cells (2)
Thanks Mike, but I'm confused. I can't figure out how to select both columns, then sort LARGE just one column, and where I put this command, (in one cell or more)? Could you please give more detail. Thanks, Dan
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking cells | Excel Discussion (Misc queries) | |||
Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
linking cells | Excel Worksheet Functions |