Search

Remove Duplicate Rows

Home
Developer Guide
Functions
Remove Duplicate Rows

Last Updated: May 27, 2021

Articles

Use this function to delete all the rows that are duplicated in a specified range and return the number of rows remaining in the range.

Syntax

Remove Duplicate Rows (range, has_header)

Parameters

Input Parameter Name Description
range First cell to last cell value separated by : to remove duplicate rows
has_header true if the header is included, false if the header is not
  1. If true, the first row is considered as header and will not be verified for duplicate data.
  2. If false, the first row is also considered as data for verifying the duplicate data.

Returns

Return value Description
Rows Returns the number of remaining rows in the range

Sample

Remove Duplicate Rows (C3:F8, true)

  • Removes duplicate rows from the cell range C3 to F8.
    Returns 2, the number of remaining rows in the range.

To view all the Excel functions, click here.

Did you find what you were looking for?