Results 1 to 9 of 9

extract all values in column, excluding immediate duplicates only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    541

    extract all values in column, excluding immediate duplicates only

    I have a list of names in a column. they appear in duplicate groups but the groups can occur more than once. I need a way to list each name from the column in order but exclude immediate duplicates but not other instances of the same name later on. If that makes since. The list on the left would become the list on the right.

    Me Me
    Me You
    Me Them
    You Me
    You You
    You
    Them
    Them
    Them
    Me
    Me
    Me
    You
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract from vertical list excluding blank and duplicates
    By Sekars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2022, 01:49 AM
  2. [SOLVED] Extract Values in a Column Excluding Blanks
    By bjnockle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2020, 01:32 PM
  3. [SOLVED] Extract Unique values from the list of Duplicates and copy into another column
    By nadeemm in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-20-2018, 11:58 AM
  4. [SOLVED] Extract numbers for given creteria excluding duplicates
    By Sekars in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2017, 11:06 AM
  5. Frequency of occuring values excluding duplicates
    By Ollypetcon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2014, 01:03 PM
  6. [SOLVED] Populate ComboBox from a column excluding duplicates?
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2013, 02:06 PM
  7. [SOLVED] Linking to a column of values, excluding duplicates?
    By bauerbach in forum Excel General
    Replies: 5
    Last Post: 06-25-2012, 02:13 PM

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