Grouping and counting

[Brent Hauver]

I want to get the number of transactions per day... The data looks like
below.. I first need to mask out everything leaving the day and then I need
sort, and group dates on transactions and then sum up the transactions per
day... then I can get a average of transactions per day... Appreciate any
help...

Date Sold Transaction
2/27/2004 9:43 46724
2/27/2004 15:52 46747
2/27/2004 15:55 46748
2/27/2004 15:55 46748
2/27/2004 15:55 46748
2/27/2004 15:55 46748
2/27/2004 15:55 46748
2/27/2004 17:44 46750
2/28/2004 8:57 46752
2/28/2004 10:17 46754
2/28/2004 10:23 46755
2/28/2004 10:23 46755
2/28/2004 10:23 46756
2/28/2004 13:54 46778
2/28/2004 14:03 46779
2/28/2004 14:03 46779
3/1/2004 9:45 46797
3/1/2004 9:45 46797
3/1/2004 10:31 46798
3/1/2004 10:31 46798
3/1/2004 10:36 46799
3/1/2004 11:01 46801
3/1/2004 11:52 46802

 

[Barb Reinhardt]

If it were me, I'd create a column for the date only (no time). If you have
your date and time currently entered into the same field, you can convert to
date with the INT function. The result will be the date at 12 AM each
day. I'd then use a pivot table to determine what's needed for each date.

 

[JulieD]

Hi Brent

to add to Barb's comments - check out www.contextures.com/tiptech.html for
details on creating & using pivot tables - they will make your life much
easier

Cheers
JulieD