+ Reply to Thread
Results 1 to 2 of 2

VBA Matching Data Output Matched results

  1. #1
    Registered User
    Join Date
    05-11-2018
    Location
    uk
    MS-Off Ver
    uk
    Posts
    1

    VBA Matching Data Output Matched results

    Hello All,

    I am certainly not the most proficient at VBA and have (what i think!) is a relatively simple need.

    Column A - This contains a list of e-mail addresess
    Column B - This also contains a list of e-mail addresses.

    I am looking to output into column C all the matched e-mail address's without any duplicates. The end goal being that there is a complete third list with e-mail addresses unique e-mail address's based on them being contained in both column A and column B. For Example

    Column A Column B Column C
    Email1attest Email2attest Email1attest
    Email3attest Email1attest Email2attest
    Email2attest Email4attest
    Email5attest Email4attest
    Email5attest Email4attest
    Email1attest Email2attest



    I wrote something but found a better snippet online that doesnt do quite what i want to do. it highlights matched data rather than outputs. Whatever i try to do to get this to output into column C i cant seem to get it to work.

    Please Login or Register  to view this content.
    Any help would be really appreciated

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,808

    Re: VBA Matching Data Output Matched results

    Are you capable of adapting the code from this thread to your needs ?
    https://www.excelforum.com/excel-new...ate-match.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare values and output cell titles, able to output multiple results
    By TMG2016 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2016, 11:42 AM
  2. [SOLVED] Create Data validation list from matched criteria value results
    By lukeeb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-10-2014, 10:39 PM
  3. Divide selected data into groups, use formulas on data, the output results
    By papuanewguinea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2013, 06:04 PM
  4. Replies: 2
    Last Post: 03-25-2013, 04:07 PM
  5. Replies: 1
    Last Post: 03-13-2012, 09:45 AM
  6. Matching column data and output to cells
    By addj in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-10-2011, 03:23 PM
  7. Matching Two sets of Data and Get a New Output Sheet
    By crapmind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2007, 03:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1