Too many questions, not enough answers. What version of excel are you using?
Do you want the duplicate names deleted from THIS list, or do you want the unique names listed elsewhere? When a name is "added" to the list, are you wanting the name to be "automatically" added to the unique list if it isn't already there? What type of solution are you looking for? Are you comfortable with VBA macros? Paul ________________________________ From: sudhir kumar <bluecore...@gmail.com> To: Excel Group <excel-macros@googlegroups.com> Sent: Tue, March 15, 2011 8:20:32 AM Subject: $$Excel-Macros$$ How to short repeated name Dear Experts i have list of reapted name. and i want a list which have name only one time if any new name add in list then it will add name. example List of Repeated name: A B H E A H A H I A B I List should be this type: A B H E I thanking you -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir VermaAsstt. Mngr. A/c's 9818479722 P think Before you print Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. Happy Valentine Day \ ¦ / (ò ó) _____ ___o0o___(_)___o0o__ ___¦_____¦_____¦_____¦_____¦ ¦_____¦_____¦_____¦_____¦__ ___¦_____¦_____¦_____¦_____¦ Drink Bear Save Water -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel