+ Reply to Thread
Results 1 to 5 of 5

Retrieve values from 1 column and only show non-duplicate values.

  1. #1
    Registered User
    Join Date
    05-26-2020
    Location
    Lynnwood, WA
    MS-Off Ver
    2016
    Posts
    18

    Retrieve values from 1 column and only show non-duplicate values.

    I know this is a relatively simple formula but my brain is just not clicking for some reason.

    In column A I have a bunch of names.

    Jane Smith
    Joe Smith
    Jane Smith
    Joe Dover
    Jane Dover
    Don Smith
    Joe Smith
    Jane Dover

    In column B, I want it to show unique values and skipping the duplicates. I want it to a dynamic setup where it'll only pull 1 unique value and skip the duplicate names.

    Jane Smith
    Joe Smith
    Joe Dover
    Jane Dover
    Done Smith
    etc
    etc

    Thank you everyone!

  2. #2
    Registered User
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    94

    Re: Retrieve values from 1 column and only show non-duplicate values.

    You can copy all of Column A into Column B.
    Go to Data tab.
    Click on Remove Duplicates.
    Continue with the current selection.
    Click on Remove Duplicates.
    Box will pop up with Column B checked.
    Click on OK.
    Tells you how many duplicates were removed and how many unique entries remain.
    Click OK.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,580

    Re: Retrieve values from 1 column and only show non-duplicate values.

    Hello whoisdane. Welcome to the forum.

    When you say you want it to be a dynamic setup what exactly does that mean? Will the list(s) be variable in size ... something else?
    Dave

  4. #4
    Registered User
    Join Date
    05-26-2020
    Location
    Lynnwood, WA
    MS-Off Ver
    2016
    Posts
    18

    Re: Retrieve values from 1 column and only show non-duplicate values.

    Hi Everyone - I ended up creating an array formula to automatically show unique values from a specific column. Unfortunately that ended up taking up a ton of computing power so I ended up scrapping that idea and writing a macro that automatically copies and pastes a unique value list every time the workbook is saved.

    It works way better and more smoothly. Thanks everyone for the willingness to help!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,641

    Re: Retrieve values from 1 column and only show non-duplicate values.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. How to delete entire row if duplicate values show on a column?
    By Gordon85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2020, 04:43 AM
  2. I need to club two column values and search with it to find duplicate values
    By Abhimanyu.bade in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-21-2018, 10:31 AM
  3. [SOLVED] Putting a zero in column B for duplicate values and 1 for unique values
    By treeantz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2016, 12:37 AM
  4. detecting duplicate values in a column (values are made of formula)
    By louiemangaring in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2015, 06:25 AM
  5. [SOLVED] Need Urgent help on Adjacent values of Duplicate column values should be be in single row.
    By anto_01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 09:55 PM
  6. retrieve unique data with duplicate values.
    By yrndtn in forum Excel General
    Replies: 0
    Last Post: 03-06-2011, 08:40 AM
  7. Replies: 14
    Last Post: 10-19-2010, 11:52 AM

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