Problem description & analysis:

The Excel table below has 7 columns of numbers. Some rows are completely the same.

We want to remove duplicate rows.

Solution:

Enter the following formula in SPL XLL:

=spl("=?.group(~).select(~.len()==1).conj()",A1:G7)

As shown in the picture below:

Explanation:

group()function groups rows. select() function gets groups meeting the specified condition. conj() function concatenates the selected groups.

ℹ️ Feel free to download esProc Desktop and explore the related information:

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming