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 ent
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] <[
can you send the file.
Regards
CA. Atul Singhal
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: November 06, 2008 2:58 AM
To: MS Excel & VBA Macros
Subject: $$Excel-Macros$$ Excel Macros totaling like values
How do I create a macro in Excel that will count t
