Results 1 to 6 of 6

Thread: Create a sorted list of uniques based on 2 columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Junior Member
    Join Date
    Jun 2015
    Posts
    9
    Rep Power
    0
    Hi Admin,

    Thanks for your reply,
    I came across this article, but I couldn't quite figure out how to use this one for 2 lists. Frankly, I don't completely understand the formula in the article and don't see where the formula actually sorts. Also, the formula in the article sorts the complete list, instead of returning unique values.

    Any help would be highly appreciated!

    Thanks,
    Auckland, NZ

Similar Threads

  1. Replies: 3
    Last Post: 11-16-2013, 02:05 AM
  2. Replies: 14
    Last Post: 10-23-2013, 01:24 PM
  3. Compare two columns to sheet3 based on condition
    By vengal in forum Excel Help
    Replies: 2
    Last Post: 09-14-2013, 11:15 AM
  4. Replies: 5
    Last Post: 12-05-2012, 03:01 AM
  5. Create list with arrays
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 04-10-2012, 11:05 PM

Posting Permissions

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