Results 1 to 2 of 2

Check for consecutive exact values in a column and merge the cells in adjacent column

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Check for consecutive exact values in a column and merge the cells in adjacent column

    Dear Forum,

    I need to check whether the value in a specific column B is exact if yes the n it should merge those many number of cells in the adjacent column.
    Ex: if I have the First Row as Header and in my Column B if the cell B2 and cell B3 contain the same values then the cells C2:C3 should get merged.. if there are more than 2 cells with the same value in the same column then those many cells should get merged in the adjacent column C and if the value changes then the Un-Merging should also happen.
    Ex: If there were 4 cells in the Column m from B2 till B5 with the Value DOnald then the CElls C2:C5 are Merged but if i Change the value in the cells B3 then cells C2,C3 should be Un-Merged while C4:C5 would be Merged as the values are still same in the column B.

    Warm Regards
    e4excel
    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] Merge similar cells in column and adjacent columns
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2016, 06:58 AM
  2. Replies: 9
    Last Post: 12-29-2014, 03:07 AM
  3. Replies: 1
    Last Post: 03-02-2013, 05:06 AM
  4. Average range of cells in column if values in adjacent column are equal
    By RyNye in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 10:12 AM
  5. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  6. Replies: 0
    Last Post: 07-27-2010, 03:08 PM
  7. Script to check for duplicates in one column then alter adjacent column values
    By SebN in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2010, 12:23 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