Results 1 to 8 of 8

Merge two columns with non-duplicates and sort

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Merge two columns with non-duplicates and sort

    Hi guys. I have a new problem that I hope you can help me out.

    In my workbook I have three ranges of data. Each range contains 4 columns. I would like to merge the values from B:E with L:O only if the name in col B cannot be found in col L. All the names that can't be found will be added in the L:O list in a new range T:W. Where I would also like the data to be sorted alphabetically. A sample with an expected result has been made

    Hope this makes sence and thanks for looking into it.
    Alex
    Attached Files Attached Files
    Last edited by Zaeguzah; 06-15-2010 at 09:23 AM.

Thread Information

Users Browsing this Thread

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

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