We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

unique cell or delete the lines with all the duplicate [closed]

asked 2017-08-27 09:24:13 +0200

dimzev gravatar image

updated 2021-05-30 14:11:01 +0200

Alex Kemp gravatar image

I have a column of thousands of records whose cells are filled with text. I want to find the unique cell entries in the column with a filter or delete the lines with all the duplicate or triplicate records.. example{ pat, smith, johnson, pat, smith, smith}

the result (unique value)must be only: {johnson}

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-30 14:11:10.113272

2 Answers

Sort by » oldest newest most voted

answered 2017-08-27 09:36:50 +0200

JohnSUN gravatar image

updated 2017-08-27 13:53:15 +0200

It's very easy

Just choose Data - Filter - Standard Filter

image description

In case you need ONLY UNIQUE VALUES, use this technique.


edit flag offensive delete link more


My friend thank you for your immediate answer but there is a problem... I WANT ONLY the unique recordings !! I do not want to keep value from duplicate ... Can you help me with this?

dimzev gravatar imagedimzev ( 2017-08-27 09:49:07 +0200 )edit

Oh, please forgive me! I forgot that you already asked about this and described the problem much more. I add small animation to my answer. Perhaps this will help you?

JohnSUN gravatar imageJohnSUN ( 2017-08-27 13:50:23 +0200 )edit

My friend this is perfect !! is that I really needed !!! Thank you very much It should be added as a basic tool to libreOffice. is clearing a list

dimzev gravatar imagedimzev ( 2017-08-27 14:50:11 +0200 )edit

+1 @JohnSUN for cool animation, how do you produce those if i might ask?

librebel gravatar imagelibrebel ( 2017-08-28 00:41:26 +0200 )edit
JohnSUN gravatar imageJohnSUN ( 2017-08-28 05:59:45 +0200 )edit

very nice, i searched for a similar package on Ubuntu, came up with Peek.

librebel gravatar imagelibrebel ( 2017-08-29 00:42:30 +0200 )edit

Thanks. It's helped

acceess gravatar imageacceess ( 2020-04-23 08:47:40 +0200 )edit

answered 2018-06-15 23:06:56 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

On my CALC sheet, when I put the info that shows in 1st picture, I do not have a data range box. Where does that come from?

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-08-27 09:24:13 +0200

Seen: 7,036 times

Last updated: Jun 15 '18