The formula for displaying the Name in cell C4 is =OFFSET(Data!$D$4, B4,0). Using OFFSET to populate the Directory worksheet allows you to sort the Data worksheet and even insert and remove rows, without causing #REF! errors in the Directory.
The OFFSET( reference, offset_rows, offset_columns) function provides a powerful way to reference another cell. Step 2a: Create groups of columns for Row #, Name, and Phone The Directory worksheet will be used for printing the multiple-column phone list, so create it using whatever formatting, fonts and colors you want. Step 2: Create a separate Phone Directory worksheet I've named the Table "ContactList" via Formulas > Name Manager. This is a special feature in Excel that allows you to use structured refences. The contact list can be formatted as an Excel Table by going to Home > Format as Table. Our data source is a separate worksheet with an Excel Table consisting of names, phone numbers, and other contact information (created using the Contact List Template).
Openoffice columns list template how to#
The problems were how to make the directory update automatically when the data source was sorted, and how to prevent #REF! errors when rows were deleted from the data source. I created this template to answer a question posed to me by Jonathan Weinraub about how to make a sortable 2-column phone directory. Creative Ways to Use Contact Lists Create a Running Balance in Excel that Allows you to Insert, Delete, and Move Rows INDEX-MATCH lookup formula How to Create a Sortable 2-Column List in Excel
0 kommentar(er)
