+ 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
    27

    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
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    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
    Office 365 v 2403
    Posts
    13,396

    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
    27

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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