Domain Manage

Excel Help please!

Discussion in 'General Board' started by figleaf007, Apr 28, 2014.

Thread Status:
Not open for further replies.
  1. figleaf007 United Kingdom

    figleaf007 Active Member

    Joined:
    Oct 2006
    Posts:
    910
    Likes Received:
    8
    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!
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
     
  3. Edwin

    Edwin Well-Known Member Exclusive Member

    Joined:
    Apr 2005
    Posts:
    8,460
    Likes Received:
    261
  4. Edwin

    Edwin Well-Known Member Exclusive Member

    Joined:
    Apr 2005
    Posts:
    8,460
    Likes Received:
    261
    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
     
  5. Edwin

    Edwin Well-Known Member Exclusive Member

    Joined:
    Apr 2005
    Posts:
    8,460
    Likes Received:
    261
    • Like Like x 1
  6. figleaf007 United Kingdom

    figleaf007 Active Member

    Joined:
    Oct 2006
    Posts:
    910
    Likes Received:
    8
    That first link on your last post is the money shot, thanks Edwin :)
     
Thread Status:
Not open for further replies.

Share This Page