+ Reply to Thread
Results 1 to 2 of 2

Identifying and selecting adjacent duplicate values

  1. #1
    Registered User
    Join Date
    01-19-2017
    Location
    Milwaukee, WI
    MS-Off Ver
    2010
    Posts
    6

    Identifying and selecting adjacent duplicate values

    My goal is to select and merge all adjacent duplicates in a given column. The obstacle I've come to is selecting the duplicates to merge. I've written code to insert a 'helper column' that returns a 1 at the top and 2 at the bottom of all ranges to be merged. I have yet to figure out any way to use this column to actually select the appropriate cells. I've also thought about inserting a new row to separate the ranges to be merged and to create a natural breakpoint.


    Capture.PNG

    If it's easier to visualize, I want to merge all cells between the borders, or all cells in each range from 2->1.

    Thanks!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Identifying and selecting adjacent duplicate values

    Well, I can't see the picture, since it is posted as a PNG. I don't know what portion of the readership can't see PNG, but more importantly, it's best if you post a sample workbook so we have some live data to play with.

    If all you want is a unique list of values, then a pivot table should be able to do that for you.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Identifying duplicate values in a row, and change the value with them
    By Cody0812 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2016, 09:18 AM
  2. [SOLVED] Identifying Duplicate Values (2nd, 3rd, and 4th occurance)
    By Montoro22 in forum Excel General
    Replies: 2
    Last Post: 07-31-2013, 11:30 AM
  3. [SOLVED] Help needed! Identifying duplicate values with functions
    By PdubNZL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2013, 08:19 PM
  4. [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
  5. Identifying duplicate lines using multiple values
    By dantray in forum Excel General
    Replies: 8
    Last Post: 02-09-2012, 10:51 AM
  6. Identifying Range of Different Duplicate Values
    By stonegwene in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2011, 02:05 PM
  7. Selecting values from adjacent rows
    By illinge in forum Excel General
    Replies: 3
    Last Post: 11-05-2009, 10:38 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