Try useing "Pivot Tables" this is what they are designed to do. It will
take a little trial and error to get the results you want - but once
you understand how they work it is a great tool for what you want to
do. The default is to "Sum" everything - but you can also select count
- which is what you want to do. Select your Columns - Then put you
"Dates" in the Row selection then Put your "Other Column" in the Column
Part of the Pivot Table and also in the "Data Area"
The below is a quick representation of the PIVOT TABLE
It always defaults to a "NEW SHEET" and after you add new info in your
Table - Just
Count of Status Status
Date Closed Open Received Grand Total
1/5/2006 1 1
1/6/2006 1 1
12/5/2006 1 1
Grand Total 1 1 1 3


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498155