View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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