how to make repetative value unique?

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to make a column of repetative data become unique? 1
Remove title bar and phase bar by default on swimlane 0
Consolidate of data using formula in Excel 7
match value within any portion of lookup string in range 3
Rolling average 2
Database design 1
Database structure 1
List all tables, including document structure 0

Top