Find duplicates and counting
Jul 21, 2021
Example
There is an Excel file Book1.xlsx, part of the data is as follows:
If there is a duplicate name, fill in 1 for dup, otherwise fill in 2. The result is as follows:
Write SPL script:
A1 Read Excel data
A2 Traverse each data, if the NAME is repeated, dup will be 1, otherwise it will be 2