Excel Help please!

figleaf007 · Apr 28, 2014

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!

Edwin · Apr 28, 2014

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!

Edwin · Apr 28, 2014

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