Grouping large amount of data by day-of-week

D

Dan

I have a table with three columns; Date, Type and Day. The Day column was set
up by creating it from the date column (Format!Number!Custom!DDDD). There is
three years of data amounting to 22690 records. The Type column is for five
types of vehicles; car, pickup, van, suv and motorcycle. I want to create a
summary pivot table showing all the types of vehicles stolen on each day of
the week. For example:

TYPE Mon Tue Wed Thu Fri Sat Sun
CAR
PICKUP
VAN
SUV
MOTORCYCLE

I'm looking to find how many cars were stolen on a Monday over the three
year period. Same for the other types and days.

Thanks, Dan
 
F

Fred Smith

I see two choices. Add a column to your data, or create a calculated field
in your pivot talbe. In either case, use the formula:

=text(a1,"ddd")

Regards
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup help? 8
Line charting the same series using data from multiple sheets? 1
Payroll 2
VLookup If Date is equal to the Day 7
Automatically Insert Dates For Week Off One Day Entry 7
chart data by day of week 1
Day/Date/Week 3
Weekend dates conditional format 3

Top