collecting data

Wellcom, How I Can Delete Any Repeated Name(I Mean, Same Name), In Excel Sheet???
Eg:Telephone
Faxe
Mobile
telephone
Telephone
Mobile

How Can I Sort Or Delete THe Repeated Items Or Names.



Drunky

This link should help

http://www.cpearson.com/excel/deleting.htm

or without a macro use the forumla on the attached link and then autofilter columns and delete tagged items marked with 1

http://www.contextures.com/xlPivot07.html#Unique

VBA Noob