LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default counting number of entries for a date


Count number of rows/enties for the same DATE
I need a macro to count number of rows for the same date and displa
the result in the "Date number" Sheet.

It should pick up all the different date in the worksheet and coun
number of entries for that date and display the result

Sample Data:
08/07/2005
08/07/2005
08/07/2005
08/07/2005

10/07/2005
10/07/2005

Output:
08/07/2005 4
10/07/2005 2


Can anyone help me! Thank

--
kevinh
-----------------------------------------------------------------------
kevinhd's Profile: http://www.excelforum.com/member.php...fo&userid=2482
View this thread: http://www.excelforum.com/showthread.php?threadid=38552

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting the number of different entries in a column Wombat Excel Discussion (Misc queries) 2 January 29th 10 10:58 AM
Counting the number of entries in a column Wombat Excel Discussion (Misc queries) 7 January 20th 10 02:20 PM
Counting entries by date mebsmith Excel Discussion (Misc queries) 2 August 27th 08 05:37 PM
Counting the number of date entries in a giving month Philgr Excel Discussion (Misc queries) 4 August 22nd 06 10:55 PM
Counting number of row entries BobD Excel Discussion (Misc queries) 1 June 21st 06 09:10 PM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"