Remove Duplicates
Last Updated: Dec 1, 2020
Last Updated: Dec 1, 2020
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.
Remove Duplicates (source_range, header_included)
| Input Parameter Name | Description |
|---|---|
| source_range | Two cell values (first cell and last cell) separated by ‘:’ to remove duplicate rows |
| header_included | true if the header is included, false if the header is not included |
| Return value | Description |
|---|---|
| Rows | Returns the number of remaining rows in the range |
Remove Duplicates (C3:F8, true) => 2
To view all the Excel functions, click here.