Removing both sets of duplicates in EXCEL

November 26, 2009 at 05:52:05
Specs: Windows XP, ?
I have 2 files of several thousand CDs. The first has everything listed (about 5,000 lines), the second has several thousand titles less (about 3,500 lines - basically, the ones I have sold).

I have merged the two files to create a file where the unsold items are duplicated. What I am trying to do is create a 'sold' file, containing ONLY the lines that are are NOT duplicated. In other words, where the lines are duplicated, I need to remove BOTH duplicated lines.

In other words, I want the end result to be the approx. 1,500 lines that are in the first file, but not the second.

Any idea how I can do this.

See More: Removing both sets of duplicates in EXCEL

Report •

November 26, 2009 at 05:55:44
EDIT : The second file (3,500 items) is the titles I have NOT sold.

Report •

November 26, 2009 at 08:27:35

I suggest you post your question in the Office software forum, which includes issues about Excel.

It would be useful to include an example of the unique identifier for each record, which column it is in, and how many columns each record takes up - or is all the data about each CD in one cell - if so include an example, or several examples if the information on each CD can take different forms.


Report •

November 26, 2009 at 11:05:49
Thanks...I have done....more detailed version is here :

Cheers :)

Report •

Related Solutions

November 26, 2009 at 11:33:23
Put the info into a database, and then make a very simple report, to get what you want. Excel is much harder to get such reporting out from. There are very easy ways of converting XLS files into databases (save as whatever-delimited files), then upload that info into database.

Report •

November 26, 2009 at 11:37:45
I've searched Office 2007 and there does not appear to be a database program. Have I missed it? If so, what is it called?

Report •

Ask Question