DEV Community

Cover image for #95 — Identify Duplications of Simple Members
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks

Posted on

2 1 1 1 1

#95 — Identify Duplications of Simple Members

#beginners #programming #tutorial #productivity

Problem description and analysis:

Here below is a data table of names:

source table

Task: Identify whether there are duplicate names, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0.

Solution:

Use SPL XLL and enter the formula in cell B2:

=spl("=if(?1.conj().select(~==?2).count()>1,1,0)",A$2:A$6,A2)
Enter fullscreen mode Exit fullscreen mode

Then drag B2 down to every relevant row:

result table

Download esProc Desktop for FREE and improve your data processing workflows!!! 🚀🔥⬇️

✨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

profile
Sentry
 Promoted

Sentry image

Hands-on debugging session: instrument, monitor, and fix

Join Lazar for a hands-on session where you’ll build it, break it, debug it, and fix it. You’ll set up Sentry, track errors, use Session Replay and Tracing, and leverage some good ol’ AI to find and fix issues fast.

RSVP here →

Top comments (1)

Collapse
 
judith677 profile image
Judith-Data-Processing-Hacks •

Share your thoughts and feedback! We'd love to hear:

💭Discord
💭Reddit

profile
Sentry
 Promoted

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Read next

prince_beec5ccde00b7c6c73 profile image

Animation loader with latest ui/ux effects using the html css and javascript

Prince -

mikeyoung44 profile image

AI Training Breakthrough: New Method Creates Better Language Models by Rewriting Text for Different Audiences

Mike Young -

mikeyoung44 profile image

Quantum Computing Breakthrough Makes Drone Delivery Routes 15% More Efficient

Mike Young -

mikeyoung44 profile image

AI Video Generation Breakthrough: 3D Points Make Motion Look More Natural and Physics-Based

Mike Young -