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

©2026 Poal.co

668

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 (edited )

excel has an option called 'conditional formatting' that is up on the main menu. click on it, and there is a drop down called 'highlight cell rules' and then you select 'highlight duplicate values'. i dont know if libre office has this functionality. as an accountant, libre office is shit. i say that as a bit of an open source nerd, too

here's a link to screenshot: https://files.catbox.moe/qm4afh.png

there are other ways mentioned here in this thread, i just thought id point this method out too