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