Link to home
Create AccountLog in
Avatar of Pearlyn Tan
Pearlyn Tan

asked on

Merge and Label cells if same value

How do I merge cells of same value then label each row of the merged cell by a serial number?
Assuming I have this:User generated imageand I am trying to achieve this:User generated image
I found a way to merge the cells if they are of the same value
For i = 4 To Range("A" & Rows.Count).End(xlUp).Row
    If Cells(i, 1) <> "" Then
        If Cells(i, 1) = Cells(i - 1, 1) Then
            Range(Cells(i, 1), Cells(i - 1, 1)).Merge
        End If
    End If

Open in new window


Any suggestions on how I can proceed with the labelling? Maybe a "do while", but I'm not sure how to make sure it restarts from 1 if the adjacent cell is not merged.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Pearlyn Tan
Pearlyn Tan

ASKER

Works perfect. Thank you very much!