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!
Bookmarks