Ask Your Question

filter formating cells

asked 2017-08-27 09:31:10 +0100

dimzev gravatar image

I have a column of thousands of records whose cells are filled with text. I can format as many duplicate entries (text color, background color, etc.) What filter should I use to select the lines with a specific formatting (text background color, for example)?

edit retag flag offensive close merge delete


You do not need to pre-format the duplicates with the color - this will only complicate the task and increase the amount of work. Just delete the duplicates, as shown in the answer to your previous question.

JohnSUN gravatar imageJohnSUN ( 2017-08-27 09:44:58 +0100 )edit

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?example{ pat, smith, johnson, pat, smith, smith}

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

dimzev gravatar imagedimzev ( 2017-08-27 10:39:09 +0100 )edit

I use in my example other names - {Davos Seaworth, Khal Drogo, Davos Seaworth, Arya Stark, Jon Snow, Samwell Tarly, etc} :-) Please see movie in previous question

JohnSUN gravatar imageJohnSUN ( 2017-08-27 13:56:33 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-08-27 15:07:31 +0100

JohnSUN gravatar image

You can use this spreadsheet - C:\fakepath\giveMeUnique.ods - as tool


edit flag offensive delete link more


Thank you my friend !!!

dimzev gravatar imagedimzev ( 2017-08-27 15:56:33 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-27 09:31:10 +0100

Seen: 32 times

Last updated: Aug 27 '17