HI Paul I am using Excel 2007
Yes i want added a new name to the list, which will effect "automatically" added to the unique list if it isn't already there. i am not to sure good in VBA macros. if it will possilbe from any formula like sumproducts. thanking you On 15/03/2011, Paul Schreiner <schreiner_p...@att.net> wrote: > 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 > -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. 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