#106 — Delete Data that Can be Paired

Problem description & analysis:

Here below is a data table:

Task: Delete the rows that have the same data in the fields of ID, Name and Item, and whose positive and negative values in Value field can be completely offset.

Solution:

Use SPL XLL and enter the following code:
=spl("=E(?1).group(ID,Name,Item).select(~.sum(Value)!=0).conj()",A1:D10)

The results are shown below:

---

Download esProc Desktop for FREE and experience the simplicity and power of SPL XLL! 🚀🔥⬇️

✨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-Excel-Sharing]

🔗 Practical, efficient, and help you save time! Discuss more tasks and simple solutions with the communities!

🧩Discord
🧩Reddit