1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

EXCEL - Trying To Match Items From One Column to another.?

Discussion in 'Business Applications' started by JPAnnett, May 25, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. JPAnnett

    JPAnnett Thread Starter

    Joined:
    May 25, 2012
    Messages:
    1
    Hi, i wounder can anybody help. In column A I have a link with a image link-in. With this link is a numeral number. In column B the numeral number i am looking for with in the link is listed. Bu they are mixed up, and there are loads of duplicates. is there a formula or a way, i can associate the codes in column B, with the Codes with in the link, in Column A. and they appear in column, C, relating to the link in coloumn A.
    I have attached a spreed sheet to show, my problem.?
     

    Attached Files:

  2. CDHarm

    CDHarm

    Joined:
    May 26, 2011
    Messages:
    251
    Hi,

    I did this in 2 parts.
    The first code will delete dups.
    The second code will look for images and copy result to column C.
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1054579