1. Home
  2. Restrict/Filter to Duplicate Rows

Restrict/Filter to Duplicate Rows

Select menu: Spread | Restrict/Filter | Duplicate Rows

Use this to apply a filter/restriction to the spreadsheet, based on rows which have more than one occurrence of specified values. 

  1. From the menu select Spread | Restrict/Filter | Duplicate Rows.

The spreadsheet will be sorted into the order of the Selected ID columns (see below). 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.

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 ID columns, or double-click items in this list to transfer them to the Selected ID columns list.

Selected ID columns

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 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, leaving a single copy of each ID in the spreadsheet.

See also

The RESTRICT directive can be used to filter columns within the command language.

Updated on July 10, 2019

Was this article helpful?