+ Reply to Thread
Results 1 to 9 of 9

Filter for Unique Values based on Two Columns

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Berlin, Germany
    MS-Off Ver
    Microsoft Excel for Mac
    Posts
    7

    Filter for Unique Values based on Two Columns

    Hi All,

    First time poster, but I'm struggling with a problem that I could use your help on. I have a large data set, and I'm trying to isolate Unique Values, but based on data in two columns.

    Here's what I mean:

    I have two columns- Column A is event name, and Column B is email address.

    My problem is this: I have duplicates in this sheet, but I also have many distinct events that have the same name but come from different email addresses. Is it possible to filter by unique values for column A as long as Column B is also distinct?

    Cheers

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Filter for Unique Values based on Two Columns

    Hi and welcome to the forum!

    If you could attach a workbook with a small example which illustrates your query, including your desired result(s) clearly outlined, then I'm sure someone will be able to help.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Filter for Unique Values based on Two Columns

    Hi jfried11,

    Welcome to the forum

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Filter for Unique Values based on Two Columns

    Have you tried to use Advanced filter? Should do the work for you (nothing in criteria just checked "only unique values)

    PS. I hope this answer is not against rule 7 - if it is - please delete this post.
    Last edited by Kaper; 02-07-2014 at 06:50 AM.
    Best Regards,

    Kaper

  5. #5
    Registered User
    Join Date
    02-07-2014
    Location
    Berlin, Germany
    MS-Off Ver
    Microsoft Excel for Mac
    Posts
    7

    Re: Filter for Unique Values based on Two Columns

    Dummy_Worksheet.xlsxDummy_Worksheet.xlsx

    Hi All,

    Thanks for the warm welcome. Please see a very simple dummy file attached, illustrating my problem and what I hope to view.

    Cheers!

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Filter for Unique Values based on Two Columns

    after advanced filter (A1:B11 selected and the procedure as described above)
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-07-2014
    Location
    Berlin, Germany
    MS-Off Ver
    Microsoft Excel for Mac
    Posts
    7

    Re: Filter for Unique Values based on Two Columns

    Hi All,

    Well, that works. Didn't realize it quite that simple, feel very foolish. Thanks!

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Filter for Unique Values based on Two Columns

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #9
    Registered User
    Join Date
    02-07-2014
    Location
    Berlin, Germany
    MS-Off Ver
    Microsoft Excel for Mac
    Posts
    7

    Re: Filter for Unique Values based on Two Columns

    Ah, thanks for the heads up Arlu. Have set the status.

+ 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. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. Replies: 1
    Last Post: 11-16-2013, 05:18 AM
  3. [SOLVED] Count unique values in columns based on 2 criteria
    By t83357 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 04:33 PM
  4. Count Unique Values based on 2 columns
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 02-14-2012, 11:27 AM
  5. count unique values in columns based on date values
    By cclntn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2010, 06:16 PM

Tags for this Thread

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