how to make repetative value unique?

[mango]

dear all,
if i hv a column of repetative data, what function to use to make it unique?
not manual select and delete

course title ------> course title
RISK MANAGEMENT RISK MANAGEMENT
RISK MANAGEMENT SAFETY TIPS
SAFETY TIPS
SAFETY TIPS
SAFETY TIPS
SAFETY TIPS

 

[Norman Harker]

Hi Mango!

See:
Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

All you need for handling duplicates / unique problems.