Inquiries for a given date (Over my head)

jpifer

New Member
Joined
Jan 24, 2005
Messages
1
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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
ABCD
3CountofInquiries
4InquiriesTotal
51/29/20052
62/3/20051
72/5/20053
82/10/20051
92/11/20052
102/12/20053
11GrandTotal12
Sheet5


Hope that helps,

Smitty
 

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267
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'
 

Forum statistics

Threads
1,148,525
Messages
5,747,194
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top