Counting rows

[Steve]

I have a column of data that I want to display showing a
progression based on the number of rows per date.
See below. . . there are 6 rows on 3/29, 3 rows on 3/30,4
rows on 3/31, etc.
I want to count the number of rows for each date, perhaps
define a variable for each date as a graph point and
display it in a graph of some kind. It is the logic of how
to count each date value dynamically that I just don't
know how to do.

Thanx in advance!

3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/30/2004
3/30/2004
3/30/2004
3/31/2004
3/31/2004
3/31/2004
3/31/2004

 

[Bob Phillips]

Put the counts in another range with

=SUM PRODUCT(--(A1:A100=DATE(2004,3,29))

etc.

You can use a cell with the dates and check against that

=SUM PRODUCT(--(A1:A100=H1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
one way: use a pivot table for this and create a chart based on the
pivot table result (use the data as row item and countof date as data
item).
Also see the following sites:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html