Cells in column A contain certain values.
How can I eliminate the same values in subsequent cell(s)?


Example.

Original worksheet:

A
1 DOG
2 12
3 CAT
4 15
5 BRUCE
6 DOG
7 1
8 2
9 CAT
10 DIANE
11 CATHY
12 3
13 DOG
14 15
15 PRUFROCK
16 HORSE
17 16
18 4
19 MOUSE
20 23
21 22
22 21
23 CAT
24 JOHN
25 DOG
26 JACK
27 26
28 HORSE
29 5
30 6
31 CAT
32 CAT
33 12
34 DOG
35 6
36 7
37 CAT
38 DOG
39 MOUSE
40 13
41 HORSE
42 52
43 DOG


Result:

A
1 DOG
2 12
3 CAT
4 15
5 BRUCE
6
7 1
8 2
9
10 DIANE
11 CATHY
12 3
13
14 15
15 PRUFROCK
16 HORSE
17 16
18 4
19 MOUSE
20 23
21 22
22 21
23
24 JOHN
25
26 JACK
27 26
28
29 5
30 6
31
32
33 12
34
35 6
36 7
37
38
39
40 13
41
42 52
43