Remove Duplicates Fast

Tags: Calc Extensions

Rating: ★ ★ ★ ☆ ☆

Remove Duplicates Fast will delete all duplicates from your cell range in LibreOffice Calc

remove duplicates fast 5a10753c 68ac 48a0 b307 89cb4f5dbb4c

Description

It will add own toolbar with only one button and menu item Remove duplicates into menu Data

This extension is fork of https://extensions.libreoffice.org/extensions/remove-duplicates extension.

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 1.0.6 Fixed selected range after work of extension 6.1 Linux, Windows, macOS GPL Download
  • 1.0.5 Updated algorithm
    Added translating to Russian
    6.1 Linux, Windows, macOS GPL Download
  • 1.0 First release 6.2 Linux, Windows, macOS GPL Download

Other Extensions

Formatting of All Math Formulas

This extension allows formatting of all (or selection) Math formulas in your document. Works in Writer, Calc, Draw and Impress.

★ 4

10-2020

Remove Duplicates Fast

Remove Duplicates Fast will delete all duplicates from your cell range in LibreOffice Calc

★ 2.6666666666667

10-2020

Feedback

★ ★ ★ ☆ ☆

Post your review

Reviews

  • Toni Rocha Nov 9, 2020, 8:57 AM (19 days ago)

    ★ ★ ★ ★ ★

    Good extension. LibreOffice needs it to remove duplicate rows based in specific columns.

  • Tried It Oct 16, 2020, 8:46 PM (42 days ago)

    ★ ☆ ☆ ☆ ☆

    Tested it on a sheet of 117 lines, 7 of which were correctly identified as being/having duplicate lines by Conditional Formatting. "We found and deleted 2 duplicated values. Now we have only 111 unique values" this extension told me, so it only found and removed 3/7 duplicates, for an error failure greater than 50%.

    • Tried It Some More Oct 16, 2020, 8:50 PM (42 days ago)

      To it's credit, for some reason it will find all the duplicates if I sic it on just one column at a time. So if I have it scan only Column A, it does find all 7 duplicates. But if I have scan Columns A-E, then for some reason it only finds 4. Weird.

      Also, I would like a way to review the found duplicates and remove only those I tell it to as my work involves some apparent dupes that actually should not be removed, so I need a way to just organize all the dupes together, and then use my judgment to delete both instances of some, and delete only one instances of others.

      • Roman Oct 31, 2020, 6:35 PM (28 days ago)

        It calculate duplicates in all selected columns for one time.
        For example, we have follow:
        1 1 1 1
        1 1 1 1
        1 1 1 2
        1 1 2 2
        1 1 1 2

        and we selected all four column in the dialog, then we'll get follow result:
        1 1 1 1
        1 1 1 2
        1 1 2 2

        the algorithm uses all four values in row as ONE value and checks with other four value row by row

        But if we'll select in our example only first column, then we'll get:
        1 1 1 1

        and all.

  • mari Sep 4, 2020, 10:41 AM (3 months ago)

    ☆ ☆ ☆ ☆ ☆

    Can't install. on Calc 7.0.0 portable.
    "an error occured durling file opening"

  • Regis Fortier Sep 3, 2020, 2:40 PM (3 months ago)

    ☆ ☆ ☆ ☆ ☆

    Hi,
    It works well till I see the popup showing to me the result (which is exact) BUT NOT DELETING (as it must do) anything... Something wrong ?

    • Roman Oct 4, 2020, 6:53 PM (55 days ago)

      Possibly. Give me more info, You can find me on LibreOffice Telegram channel

  • Gabriel Gonzalez Aug 13, 2020, 5:28 PM (4 months ago)

    ★ ★ ★ ★ ★

    It works perfectly, it should be a native function in libreoffice calc

    • Jenn Aug 18, 2020, 8:33 PM (3 months ago)

      I wish it worked for me. I keep getting an error. Any idea how to get support?

      • Roman Oct 4, 2020, 6:52 PM (55 days ago)

        Can you find me in LibreOffice Telegram channel?

  • Jeff Knox Jul 20, 2020, 3:21 AM (4 months ago)

    ★ ★ ★ ★ ★

    Seems ideal, especially for people like me who have limited experience with spreadsheets and only need to do these types of operations occasionally. I remember searching for solutions and finding answers that only someone who didn't need the answer would understand. Simple stuff, but if you don't know the lingo, you're SOL. This solves that. At least it appears to. I've only used it once and it worked perfectly. We'll see if any negatives crop up down the road.

RSS feed for reviews on this page | RSS feed for all reviews