On Fri, 8 Jul 2005 02:26:56 -0500, kevinhd
wrote:


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

It should pick up all the different date in the worksheet and count
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! Thanks

If the data is sorted as you show, my suggestion would be to record a macro
using the Data/Subtotals wizard and the Count function; then collapse the range
so you see only the counts. Use the GoTo Visible Cells option to select
appropriately; Copy/Paste and then stop the macro recording. Finally, do some
clean-up on the resultant macro.

If you have a lot of data, this should be faster than stepping through one at a
time.
--ron