Re: [libreoffice-users] remove duplicate rows in calc?

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
same)
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.

Seems cumbersome but doesn't take long.
steve

On 30/06/2020 06:40, Johnny Rosenberg wrote:
> Here's one suggestion that I found:
> https://ask.libreoffice.org/en/question/53569/delete-duplicates-in-calc/
>
> Otherwise I guess you have to write a macro.
>
>
> Kind regards
>
> Johnny Rosenberg
>
> Den mån 29 juni 2020 kl 19:20 skrev Dave Stevens <geek@uniserve.com>:
>
> > 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%.
> >
> > Dave
> >
> > --
> > 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
> > 1978
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy