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

©2026 Poal.co

1.3K

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

Conditional formatting in Excel works ok, but I prefer to use Access - queries make it really simple (it's much better than Excel when you are comparing separate lists imo - especially when they're not all in the same order, or if more entries exist in one list than the other). I also use Access to compare two reports to weed out duplicate accounts, I then have two additional queries that identify which accounts exist in one report but not the other.