Hi,
I was wondering if I could figure out a macro to do the following:

Ex:
142321
142321
999999
999999
999999
999999
121421
121421
241424
241424
241424
241424

So here, I would like to delete ones that are double-consecutively repeated (i.e. 142321) and leave only the ones that are repeated 4 times (i.e. 9999)

Thanks in advance for your help.