Remove Duplicate Rows for OpenOffice/LibreOffice
Sadly, one inevitable consequence of running lots of related keyword searches is that I ended up with a massive number of duplicate rows in the LibreOffice Calc spreadsheet that I was saving the results to.
Even more sadly, the first recipes that I found for de-duping Calc spreadsheets were rotten and incomplete.
As usual, the final solution was pretty simple and moderately elegant.
So, How To De-duplicate the Spreadsheet?
- Select the entire range containing data to filter —
- Click menu Data > Filter > Standard Filter
- Define a condition that is always TRUE, like
ColumnD = -not empty
- Select the "More options" drop-down selection box
- Choose "no duplication"
- Press OK
Every so often I run a blog on this URL — indeed, the original blog started some years before the term ‘blog’ was coined.
Anyway, the time has come to start a new work-related blog — mostly for the purpose of jotting down snippets of news, tutorials, and opinions that I haven't yet polished or digested, i.e. stuff that really isn't finished enough to publish on the WDA website.
I expect substantial amounts of Dave Fisher-related stuff to appear here before Sepertember 2012.
In the meantime, if you have known me as a friend, colleague, student, or mere acquaintance — and you want to get in touch for whatever reason — just drop me an email via the WDA web enquiries form. I'll try to get back to you reasonably quickly.
If I ever get around to publishing a personal blog again, it will appear on davidfisher.org.uk.