#104 — Deduplication of Row-Based Data — by Whole Row — Keeping the Original Order

Problem description & analysis:

There is a data table:

Task: Find out the whole-row data that are not duplicate, and the first duplicate whole-row data.

Solution:

Use SPL XLL and enter the following formula:
=spl("=E(?1).group@u(ID,Name,Gender,Birthday).(~(1))",A1:D7)

The results are shown below:

---

Download esProc Desktop for FREE and add this powerful technique to your data toolkit!! 🚀🔥⬇️

✨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

Comments

[Judith-Data-Processing-Hacks]

Explore new tools and expand your perspective with the communities!

🌟Discord
🌟Reddit