2012

Table Of Contents
To edit a formula in a formula column added to extracted data
1 Click Insert tab Linking & Extraction panel Extract Data.
2 In the Data Extraction wizard on the Refine Data page, right-click the
column label of the formula column. Click Edit Formula Column.
3 In the Edit Formula Column dialog box, make changes to the formula.
4 Click Validate.
5 Click OK.
To insert a totals footer row for a column in a data extraction table
1 Click Insert tab Linking & Extraction panel Extract Data.
2 In the Data Extraction wizard on the Refine Data page, right-click the
label for the column that will have a footer row. Click Insert Totals Footer.
3 From the flyout menu, click Sum, Max, Min, or Average.
The totals footer row is placed as the last row for the selected column.
To display the sum of numerical data in identical property rows
1 Click Insert tab Linking & Extraction panel Extract Data.
2 In the Data Extraction wizard on the Refine Data page, click Combine
Identical Rows.
3 Right-click the column label. Click Combine Record Mode Sum Values.
The sum of the numerical data is displayed.
Organize and Refine the Extracted Data | 1985