hiya,

i see lots of posts resolving the following:-

a
a
b
c
d
d
e

to

a
b
c
d
e

however what i want to do is take a column and turn

a
a
b
c
d
d
e

into

b
c
e

i.e showing me data that is present once only...

any ideas how i do this? excel 2007

many thanks