Excel Help please!

[figleaf007]

Hi guys

Going a bit mad here and would love some help;

Column 1 has names of 1000 products that we have sold
Column 2 has names of 5000 products - the 1000 we have sold and the 4000 we have not.

In column 3 I want a list of the 4000 we have not sold, have tried vlook ups and pivot tables, but all I am getting is the duplicates, I want the ones that are not duplicates ie in stock but not sold. Any ideas?

Much appreciated!

 

[EdwinEdwin is verified member.]

Looks like these threads may help...
http://stackoverflow.com/questions/...s-a-b-and-show-data-of-column-a-that-do-not-e
http://superuser.com/questions/81498/excel-find-items-in-one-column-that-are-not-in-another-column

Good luck!

 

[EdwinEdwin is verified member.]

Alternatively, if you have Watch my Domains Pro, then...

1) Sort both the 1,000 and 5,000 domain lists alphabetically
2) Paste the 1,000 sold domains into WMDP
3) Paste the 5,000 (all) domains into WMDP
4) The 4,000 domains will be all the domains that come after the last entry that was present in the first list (because WMDP only accepts 1 instance of a domain)

In other words, if list 1 is:
- cat.co.uk
- dog.co.uk

And list 2 is:
- cat.co.uk
- catch.co.uk
- dog.co.uk
- dozen.co.uk

then by pasting them into WMDP in the order I stated above you'll get
- cat.co.uk
- dog.co.uk <- last entry in the first list (so everything below this is the unsold stuff)
- catch.co.uk
- dozen.co.uk

 

[EdwinEdwin is verified member.]

Or you could use this tool...
http://jura.wi.mit.edu/bioc/tools/compare.php

Or this one...
http://www.webtoolhub.com/tn561406-list-comparison.aspx

I think that gives you enough options to choose from

 

[figleaf007]

That first link on your last post is the money shot, thanks Edwin