SIMUL8 logo

Unique Sheet

Spreadsheet rows are removed if the specified column cell is identical to the cell above

Typically only used with sort sheet, this command removes rows that are duplicates and shifts up rows into the blank space. Only designed to work if the sheet is already sorted, but does not sort the sheet first because there might be cases where it is useful for non-sorted sheets. “Duplicate” is checked in one column only.

Parameters

  • Spreadsheet - Spreadsheet column to check for uniqueness, rows above are not checked

Examples

Unique Sheet VL Command - Example 1 Unique Sheet VL Command - Example 2 Unique Sheet VL Command - Example 3

Comments This command is only available with SIMUL8 Professional 2017 and later.


See Also

logo
cleardot