WelcomeUser Guide
ToSPrivacyCanary
DonateBugsLicense

©2026 Poal.co

1.1K

Columns for each entry are: Number of source data set Number within data set First name(s) Last name DOB Date of death Age at death (formula)

Bit more than 7,000 entries so far. Using LibreOffice under Linux.

Any bright ideas on how to check for dupes using the spreadsheet?

Guess I could export the list into a text file and use some kind of dupe finder that works on those.

Columns for each entry are: Number of source data set Number within data set First name(s) Last name DOB Date of death Age at death (formula) Bit more than 7,000 entries so far. Using LibreOffice under Linux. Any bright ideas on how to check for dupes using the spreadsheet? Guess I could export the list into a text file and use some kind of dupe finder that works on those.

(post is archived)

[–] 3 pts

Is it a dupe if it matches on any, or is it on all.

I usually pass it through bash and do sort | uniq

It also depends on if you want to remove dupes or mark them. To count dupes you use sort | uniq -c | sort -n The sort -n is optional but clusters all of your duplicated ones together.

[–] 0 pt

I'll give that a try. Thank you.