Welcome • User Guide
ToS • Privacy • Canary
Donate • Bugs • License

©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)

You are currently inside a comment thread.
Click here to see all the comments (11).
[–] • 1 pt

Pivot table in excel or the cool Linux equivalent and display "count" on the entries. Anything with more than a 1 count is a duplicate.

[–] • 0 pt

That should work. Thanks.

[–] • 2 pts

It's very crude. I'm positive there are better ways to do it in excel that would hilight and group dupes but I'd be jewgling how. Also can copy/paste the results of the pivot table and then sort that to hide all the 1's.