The information in this article applies to:
SUMMARYIf 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. MORE INFORMATION
In the following example, the formulas in column D are linked to cells in
columns A and B. When you sort the data in columns A and B, the formulas in
column D are not affected. To use this example, follow these steps:
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. REFERENCESFor more information about the OFFSET function, click the Index tab in Microsoft Excel Help, type the following text offsetand then double-click the selected text to go to the "OFFSET" topic. Additional query words: XL98 howto
Keywords : xlformula xllist |
Last Reviewed: January 12, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |