Ask Your Question
0

unique cell or delete the lines with all the duplicate

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

dimzev gravatar image

updated 2017-08-27 10:37:31 +0200

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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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.

getUnique.gif

edit flag offensive delete link more

Comments

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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 3,511 times

Last updated: Jun 15 '18