Restrict/Filter to Duplicate Rows

This menu allows you to apply a filter/restriction to the spreadsheet, based on rows which have more than one occurrence of specified values. Spreadsheet will be sorted into the order of the specified ID columns. The rows which have duplicate IDs in the spreadsheet will then be the only rows displayed. This filter will replace any other existing filters on the spreadsheet. An option allows the second and subsequent occurrences to be selected so that these could be copied or deleted to reduce the spreadsheet to having only one occurrence of each ID.

This filter is useful for identifyind and removing duplicate entries.

Available Columns

This lists all the columns within the spreadsheet. Select the columns that define the row IDs. Use the

button to transfer these into the list of Selected Column IDs, or double-click items in this list to transfer them to the Selected Column IDs list.

Selected Column IDs

This lists the columns within the spreadsheet whose combination of values define the row IDs. Use the

button to remove columns that have been selected from this list of columns, or else double-click the entries to remove them.

Select rows after first unique ID

If selected, the second and subsequent rows of each duplicated ID will be selected. This will allow an operation such as Spread | Delete | Selected Rows to be used to remove these rows, just leaving a single copy of each ID in the spreadsheet.

Action Buttons

OK	Restrict/filter the spreadsheet and close the dialog
Cancel	Close the dialog without further changes.

Available Columns

Selected Column IDs

Select rows after first unique ID

Action Buttons

See Also