I have gnumeric and libreoffice calc. How to find duplicate rows? if I could use libreoffice, it's better, but anything is good for me.
I have the latest stable version of both software
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It only takes a minute to sign up.Sign up to join this community
This a way you can hide and then remove duplicate rows (or 'records') in Libreoffice Calc
Go to the worksheet that has the duplicate entries, and select 'Data' > 'Filter' > 'Standard Filter' (it seems to automatically select the data in the sheet that it will filter, you may want to do this manually beforehand).
Then in the box that pops up, select the column (Field - entering multiple 'Fields' may be possible), and as the value(s) enter 'Not Empty'.
Then under the 'Options' pop-down menu, select 'No duplications' - you may want to select other options like 'Case-sensitive', 'Copy results to', etc as well.
It should then filter the data, and hide any duplicate records. You can copy this to a new worksheet if you want to have the dataset without duplicates (instead of the dupes just being hidden).
You can reset the filter if necessary by going to 'Data' > 'Filter' > 'Reset Filter'
This worked with Libreoffice 220.127.116.11 The help page for 'Standard Filter' is here.
In order to find duplicate rows and their respective counts on MS Excel or LibreOffice you can use following formula:
=COUNTIF(A:A, "=" & A2)
It will provide count of duplicate records in the cell formula is applied on.
Explanation of formula:
You can use filter to check duplicate records with X no. of duplicacy.
Check screenshot for application of this formula:
To detect the duplicates in a column there is a solution on www.techrepublic.com. It is written for MS Excel, but it works as well in gnumeric and LibreOffice Calc.
Its mainly about this formula:
See the screenshot: