I'm looking for a way to add a number to consecutive identical values in column A.
For example:
AA
BB
CC
BB
BB
BB
DD
EE
FF
KK
KK
HH
II
JJ
KK
KK
KK
LL
Should become:
AA
BB
CC
BB
BB2
BB3
DD
EE
FF
KK
KK2
HH
II
JJ
KK
KK2
KK3
LL
Same example attached, with actual data in column A and Desired data in Column B
Test_Book.xlsx
Thanks in advance!
Bookmarks