+ Reply to Thread
Results 1 to 2 of 2

Duplicates in a list

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Duplicates in a list

    Hello. How do I PULL OUT the duplicates in a list. Not just remove them. Or it could be highlighted too. Grazie.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Duplicates in a list

    Two ways...

    1. Data tab >> Data Tools >> Remove duplicates
    2. Data >> Sort & Filter >> Advanced >> Copy to another location >> List Range: (Select the range) >> Copy to: (Pick a cell for the output) >> Check Unique records only

    There are other ways, but these two are probably the most straight forward without a formula or VBA
    HTH
    Regards, Jeff

+ 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] Copying single entries from duplicates in one list into a new list
    By zeegerman in forum Excel General
    Replies: 5
    Last Post: 11-04-2016, 06:47 AM
  2. [SOLVED] Create list of duplicates based on occurances in another list
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 07:26 AM
  3. List of unique text values from a list with duplicates
    By canoeron in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-11-2014, 11:27 PM
  4. Replies: 1
    Last Post: 04-19-2013, 02:25 AM
  5. Replies: 2
    Last Post: 08-28-2012, 10:41 PM
  6. [SOLVED] Short list of values from long list of duplicates
    By Hang Glider in forum Excel General
    Replies: 4
    Last Post: 04-21-2012, 07:13 AM
  7. [SOLVED] How to remove duplicates from a list and copy new list to new colu
    By Chance in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2005, 01:07 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