Hi, If the list is in Excel, then you can use below two options as per your choice:-
1) Use Pivot Table, put the Names in Row column and the count of the names in data field, sort the data as ascending and you have the names in alphabetcal oder and their count in the next column. 2) If you just want the unique name, then you can use Data - > Filter-> Advanced Filter and check on the checkbox against Unique records, choose the destination and click on OK. A macro can be built easily to achieve both the above tasks in a click of a button. Let me know if it solves your query, else reply with your query. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/14/09, Tommy <jntwh...@verizon.net> wrote: > > I am developing a ticket managing program for a community choir and > now have generated an extensive list of ticket purchasers by name, > where some names are repeated many times over due to multiple > purchases by the same person. I would like to generate an alphabetized > list by name, a patron list, where any given name is only found once > so that the list is not so long. I could just alphabetize the list of > data and then go in and manually remove instances where the same name > is repeated many times, but this would be time consuming. Is there > some neat way to generate a patron list automatically ? > > Tommy > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
