Deletion of dupe entries

[dnyankardore]

How can i delete dupe entries from a sheet for exemple a two persons names have been repeated thrice so how can their fuse entries be deleted and only one name is kept in the sheet?

[contaminated]

Hi pls see these video tutorials. They may help))

http://www.youtube.com/watch?v=8kd8IgyJIcw
http://www.youtube.com/watch?v=Et6k_2K6nc0
http://www.youtube.com/watch?v=4Or6vvdA6sY (with advanced Filter) Watch it first