Documentation
Compare two lists of data for differences with Excel
| Compare List compares values from one list to another in Excel. The results will identify row and column differences between the lists with the ability to update the template list to the differences found within the input list. The differences can be identified with unique colors and can automatically be tracked over time if set to do so. Compare list can be utilized to perform a simple analysis up to a comprehensive change editing and history tracking system. View Demonstration Video  |
Utility Definitions: |
|
Input/Template Relationship Tab: Input: The Input section defines where the list of data exists that will be utilized to compare to the users template list. Template: The Template section defines the user's list of data to compare. This is the list that will be modified to the differences found within the input list if set to do so. ? Select the ? button to view this documentation page Column Mapping Tab: Input Columns: The Input Columns list contains the column names within the defined input list Mapped To: The Mapped To list is where the user assigns the associativity to the Template Column list. For example, if a column name in the defined template list is File but the column name within the defined input list is My File then this is where the associativity is defined for the difference in column names between the defined input and template lists. Template Columns: The Template Columns list contains the column names within the defined template list. Clear Mappings: Select Clear Mappings to clear all defined mappings from the mappings listing. Auto Map Matching: Check Auto Map Matching on to automatically map columns with the same name. Saved Mappings: The Saved Mappings field allows a user to Retrieve, Save, and Delete predefined Mapped To settings. Matching Rule Tab: Matching Columns: The Matching Columns list contains a list of template column names that have a value defined within the Mapped To list from the Column Mapping Tab. The column names selected will be utilized to identify a matching row when comparing the differences between the input and template lists. Apply: Select Apply to run the comparison Row Results Tab: Row result list: The row result list contains the row differences between the input and template list. Select an item within the list to select/review the row within its parent list. Sheet: The sheet column is the list/list that the row was found in. Row: The row column is the row number of the row not found Status: The status column contains the value New (Not found in template) meaning the row defined by the selected matching columns was not found in the defined template list or Removed (Not found in input) meaning the row defined by the selected matching rule columns was not found in the defined input list. Action: The action column is what action will be performed to the selected items by the defined settings when selecting apply. The Add action will add the new row found within the input list to the template list at the defined Add As Row setting. The row will only be added if the Modify List setting is toggled on. The Delete action will delete the row not found within the input list from the template list. The row will only be deleted if the Modify List setting is toggled on. Column Results Tab: Column result list: The column result list contains the column differences between the input and template lists. Select an item within the list to select/view the cell within the list identified by the Selection Mode. T/Row: The T/Row column is the Template list row number of the cell difference found. I/Row: The I/Row column is the Input list row number of the cell difference found. Template Value: The Template Value column contains the cell value found in the defined template list. Input Value: The Input Value column contains the cell value found in the defined input list. Selection Mode: The Selection Mode is utilized to identify which list's cell will be selected/viewed when an item is selected within the column result list. |