ST Alpha - "and an excel question. I have a table with ~340k rows. 13k are duplicates in columns A and B. is there a way to remove the dupes," (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 163

and an excel question. I have a table with ~340k rows. 13k are duplicates in columns A and B. is there a way to remove the dupes,

Posted by mafic Nov 18 '24, 17:39

but only if they're a combined duplicate?

like don't remove
A1 = FOX B1 = 12
A2 = FOX B2 = 13

do remove one of
A3 = FOX B3 = 18
A7 = FOX B7 = 18

Responses:

Easiest might be concatenation of A/B -then remove the dupes and then delete the concatenation column. -- nm - Will Hunting Nov 18, 17:41 5
- that worked. you're a genius. -- nm - mafic Nov 18, 17:44 4
  - Cheap workarounds are my jam. -- nm - Will Hunting Nov 18, 18:05 3
    - Seriously. I could never work somewhere with good data. "I'm sorry. I can't help." -- nm - amanda Nov 18, 18:08 2
      - The positive…nowhere has good data. - Will Hunting Nov 18, 18:39 1
        
        yeah, my current company has good data managers. that's about the best I've done. -- nm - mafic Nov 18, 18:43

Post a message top

Replies are disabled on threads older than 7 days.