Finding duplicates in Libre Office Calc

LibreOfficeI recently created a spreadsheet of 5000 usernames by concatenating first_name with last_name.  As you might imagine this created a number of duplicates.  This article describes the procedure for eliminating these kind of duplicates.


Example content

Here is an example list:

A
1 usernames:
2 johnsmith
3 andrewsmith
4 jimmyjones
5 johnsmith
6 davidjones
7 johnsmith
8 andrewsmith

 

I then entered the following code for cell B2, and copied it down the column.

=COUNTIF(A$2:A$8,A2)
A B
1 usernames: Count
2 johnsmith 3
3 andrewsmith 2
4 jimmyjones 1
5 johnsmith 3
6 davidjones 1
7 johnsmith 3
8 andrewsmith 2

 

Finally I added the following code to cell C2 to make it easier to read for the large list.

=IF(B2=1,"","duplicate")
A B C
1 usernames: Count Label
2 johnsmith 3 duplicate
3 andrewsmith 2 duplicate
4 jimmyjones 1
5 johnsmith 3 duplicate
6 davidjones 1
7 johnsmith 3 duplicate
8 andrewsmith 2 duplicate

 

I was then able to filter the list against the label.

 

Thanks for visiting.