In the Excel table below, the 1^st column contains sequence numbers and the 2^nd column has duplicate values.

Task: Record the value appearing for the first time in the 2^nd column and replace its duplicates with the string "cont.".

Use SPL XLL to enter the following formula:

=spl("=((d=E(?))\d.group@1(Date)).(Date=$[cont.]),d",A1:B8)

E() function converts the data range to a two-dimensional table. group@1 groups rows and retrieves the 1^st row of each group. The operator \ finds the difference of two sets.

Source:https://stackoverflow.com/questions/78159410/select-and-replace-duplicates