Hi,

You can also try the folliwing. First of all, please ensure that you have a
suitable heading for the range (it is a good practise to do so). Therefore,
assume that the data below is in range B3:B9. In B2, type numbers.

Now in cell B13, type the following formula =countif($B$2:$B$9,B3)=1. In
cell B12, type Criteria. Now perform the following steps:

1. Go to Data Sort and Filter Advanced.
2. Click on the "Copy to another location"
3. In the list range, select B2:B9
4. In criteria range, type B12:B13
5. In the copy to box, select any blank cell.

Hope this helps.



--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jonny Ross" wrote in message
...
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