Ask Your Question

How to find and delete both original and duplicate from a list of entries [closed]

asked 2013-11-24 12:52:29 +0100

algreigau gravatar image

Hi, I need to get two computers to an identical state, so I have created a software list of each and in a CALC I have a coloured font for one and black for the other list. I have put both lists in one column of CALC and then sorted ascending. What I need to do now is to find and delete any duplicates and delete both original and duplicate entries. This will leave me with a list of packages that are on either machine, but not both. The colour of the font will distinguish the machine. There are approximately 4000 packages in each machie, so the list in column A is around 8000 lines, a prodigious task to tackle in a manual way. What tools can I use to achieve the desired result?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 21:32:15.010696

2 Answers

Sort by » oldest newest most voted

answered 2013-11-24 15:20:48 +0100

David gravatar image

updated 2013-11-24 15:21:22 +0100

There's a variant version of your question in a previous Q&A. There are some good solutions posted in that thread that I think will work for you -- if you still have the original distinct lists available! (I hope you saved them individually before merging them.)

The available solutions depend in part on the platform/OS you're using, so could you add that to your question, in case someone has a better idea for you? If you're on some flavour of Linux, for example, then cat solution that @qubit gives is superb.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-24 12:52:29 +0100

Seen: 1,851 times

Last updated: Nov 24 '13