The Problem :

Suppose I have the following data arranged in rows.

5
2
3
3
3
3
4
2
3
3
3
4
5
6
6

I wish to delete duplicate values (rows) so that the list becomes :

5
2
3
4
2
3
4
5
6

I do not wish to delete for example all the 3's except one but delete all
duplicate 3's from each group of 3's leaving a single 3 in each group.
Similarly with other groups e.g in this case the number 6.
I want to automate this process.
Note all the groups contain consecutive duplicates.
Can this be done using an excel formula or excel function or vba code ?

I welcome any suggestions

--
FLYNNE