Hi Naveen, I sorted the spreadsheet so that all entries with the same state were grouped together - and used the SUBTOTAL function. It worked well to total the number of times each state code occurs. The results I get are:
AB Count 11 AE Count 4 AK Count 7 ...and so on (there are over 35,000 entries in the spreadsheet which produced at least 50-100 results) But the results are listed after each state grouping. Now, I need to extract the results to another document, or place the totals at the end of the existing document. Is there a way to do this as a part of the SUBTOTAL process? I tried to filter the spreadsheet so that I was only shown the items that ended in "Count", but then, the totals zeroed out. What am I doing wrong? Thanks for your help... -Ena On Nov 6, 12:25 am, Naveen <[EMAIL PROTECTED]> wrote: > By using SUBTOTAL function in data menu, it can be done. > > > > > > Regards > Naveen Kumar M N > > Transport Supervisor(HP) > 91-08-99728 10886 > Email :[EMAIL PROTECTED] > > Best Wishes-Karunaada Kuvara > > --- On Wed, 11/5/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: $$Excel-Macros$$ Excel Macros totaling like values > To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com> > Date: Wednesday, November 5, 2008, 3:28 PM > > How do I create a macro in Excel that will count the number of like > values in a cell? > For Example: > > "how many people live in each city" in an excel spreadsheet of names > and addresses --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---