PDA

View Full Version : Deleting repeated cells in two column table (text)



asset
09-18-2013, 09:19 PM
Hello,

I have a file with text, one column contains original text and another translation.
Sometimes segments repeat.
For example:

segment1 - translation1
segment1 - translation1
segment1 - translation1
segment2 - translation2
segment2 - translation2

How I can delete repeated segments?

p45cal
09-19-2013, 01:05 AM
It depends on your version of Excel. If you are using Excel 2007 or later, you can use the built-in remove duplicates, see method 5 here:
http://www.mrexcel.com/tip138.shtml
otherwise use one of the other methods on that page.