There's a bug in the storage layout of some data I'm getting from an
archive that results in duplicate rows in Calc 6.4, adjacent in all the
cases I've seen. Is there a simple way to remove duplicates in this
case? Not all rows are duplicates but as high as 40%.
Affectionate tactile stimulation is a primary need, a need which must
be satisfied if the infant is to develop as a healthy human being.
And what is a healthy human being? One who is able to love, to work, to
play, and to think critically and unprejudicially.
-- Ashley Montagu – Touching, The human significance of the skin. 2e
At 10:16 29/06/2020 -0700, Dave Stevens wrote:
>There's a bug in the storage layout of some data I'm getting from an
>archive that results in duplicate rows in Calc 6.4, adjacent in all
>the cases I've seen. Is there a simple way to remove duplicates in this case?
o Select all the material.
o Go to Data | Filter > | Standard Filter... .
o Change "Field name" to "- none -".
o Click Options.
o Tick or untick "Range contains column labels" as necessary.
o Tick "No duplications".
o If desired, copy filtered material and paste back or elsewhere as desired.
That suggestion looks great, it seems to only manage 8 columns
(conditions), I will have to remember for smaller sheets.
The process at present I use on my data is to sort it in order so
duplicates always appear together. If you need the data back in original
order and don't have a column with a progression add an index column.
Then I tag rows in another column, say with IF(the row below is not the
Then I copy/paste the data to a new sheet (without formulae) and sort it
and delete non-tagged rows.
Then I re-sort back to original order.