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

©2026 Poal.co

826

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).
[–] [deleted] • 2 pts (edited )

In Excel I sort the data then compare the current row to previous row. Return true if the current row matches the previous row. Delete all rows marked as true.

[–] • 0 pt (edited )

This is what I do. Sort alphabetically then in col to right second row (B2) add formula e.g. =if(A1=A2,0,1). Double click the formula to copy all the way down.

All duplicates will have a 0 next to them, originals a 1. Now copy the new column and paste over as 'values'.

Sort by the new column and delete all the ones with a zero.

Alternatively stop being a spreadsheet faggot and learn how to use a database.