View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kevinhd kevinhd is offline
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