Grouping and counting

  • Thread starter Thread starter Brent Hauver
  • Start date Start date
B

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
 
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.
 
Back
Top