How to Delete Repeating Values in Many Rows?

[sadrap]

Hey :-)

I have an excel sheet with repeating values in many rows. I would appreciate if someone could tell me how I can keep JUST one of the repeating data and deleting the rest. For example: from A1-A9 is the same values, how can I delete from A2-A9 and just keeping A1; and so on for the rest of the sheet. I have attached some part of my data as an excel file.

Many thanks for your help in advance,
Cheers,
SAdra

[Ace_XL]

Try this..

- Select your range of data
- Go to Data -- Remove Duplicates