Article ID: 212079 - View products that this article applies to.
This article was previously published under Q212079
This step-by-step article shows you how to sort linked data without affecting cells that are linked to the original data.
If you create links to a range of cells and you sort the data to which the cells are linked, the linked cells are updated with the sorted data. This article contains an example that sorts linked data without affecting cells that are linked to the original data.
NOTE: You must select both column A and column B to sort the list in the example. The formula uses column B as the original offset row number.
For more information about the OFFSET function, click Microsoft Excel Help on the Help menu, type offset in the Office Assistant or the Answer Wizard, and then click Search to view the topic.