Re: $$Excel-Macros$$ How to short repeated name
you are talking about List of Unique Values in Excel 2007 you can use "REMOVE DUPLICATE" in Excel 2003 use : Advanced Filter (Copy to another range / UniqRecords Only / Criteria = blank) or you can use a mega-formula see my example workbook at http://www.box.net/shared/o614r2gnrj On Tue, Mar 15, 2011 at 7:20 PM, sudhir kumar wrote: > 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 > > -- -- 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
Re: $$Excel-Macros$$ How to short repeated name
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 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 > To: Excel Group > 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
Re: $$Excel-Macros$$ How to short repeated name
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 To: Excel Group 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
$$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 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
