dup

Syntax:

Return Range  dup(Range source, String newval)

Description:

Finds duplicates in source, assigns to each duplicate cell value newval and copies the modified range at the location of the current cell.

Return Range  dup(Range source, Identifier mode)

Description

Finds duplicates in source, deletes the row or column of each duplicate cell and copies the modified range at the location of the current cell.

Examples:

($a1) = dup($a1:$c10, "dupl")
Before:
AB C
1274
2144
315-332
462-7.2
591118
6171641
7228
81.10
97322
10-3721
After:
AB C
1dupldupldupl
214dupl
315dupl32
46dupl-7.2
591118
6171641
7dupl8
81.10
9dupl3dupl
10dupldupl21
($b2) = dup($b3:$b15, coldel)