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