Inquiries for a given date (Over my head)

[jpifer]

I manage a wedding photography studio and my boss has asked me to produce an excel report that shows customer inquiries for a given date. After attending a recent tradeshow, I have collected 5640 inquiries for dates in 2005. Obviously, there are a lot of multiple inquiries for a given date.
How can I produce a report that summarizes the total count of inquiries for a given date?

The list looks like this: (5640 total inquiries)
1/29/05
1/29/05
2/3/05
2/5/05
2/5/05
2/5/05
2/10/05
2/11/05
2/11/05
2/12/05
2/12/05
2/12/05

I need the list to look like this:

Date Inquiries
1/29/05 2
2/3/05 1
2/5/05 3
2/10/05 2
2/11/05 2
2/12/05 3

Thank you kindly for your time.

Jay Pifer

 

[Smitty]

Welcome to the Board!

A Pivot Table would probably be the quickest method.

Goto Data-->Pivot Table and in Layout, drag Inquiries into the Data section, where it should turn to "Count of Inquiries", then Inquiries into the Row section.

It will end up looking like this:

Book7
	A	B	C	D
3	CountofInquiries
4	Inquiries	Total
5	1/29/2005	2
6	2/3/2005	1
7	2/5/2005	3
8	2/10/2005	1
9	2/11/2005	2
10	2/12/2005	3
11	GrandTotal	12
Sheet5

Hope that helps,

Smitty

 

[KenWright]

A pivot table will do this in 30 seconds for you.

make sure your data has a heading and then select it all. Do Data / PivotTable & Chart report - Hit Next / Next / Finish. Drag the header into the ROW field, and then also drag it into the DATA field. If in the top left cell it says 'Count of header' then you're done, but if it says 'Sum of header' then right click on any one of the values that will likely be in Col B and choose 'Field settings' and then 'summarise by COUNT'