ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   linking cells (2) (https://www.excelbanter.com/excel-programming/287517-linking-cells-2-a.html)

Dan Kraemer

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

Mike Fogleman

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




Dan Kraemer

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


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com