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

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 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

Sort by » oldest newest most voted

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.

more

Stats

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

Seen: 1,695 times

Last updated: Nov 24 '13