H
hugh jass
Hello,
I am trying to do a table summary, which I believe I can accomplish with the
Pivot Table Report.
Can someone please help with what I am trying to do?
Using the following table (figure 1) as an example (comma separated incase
you'd like to copy the text, save as a .csv file, then import into Excel -
didn't want to post any attachments), I would like to build a summary based
on specific columns.
Essentially, I want the following information:
Number of cars sold by Manufacturer, date and dealer, similar to below.
manufacturer: Ford, date: 09/09/2003, dealer: 1, 1 cars sold
manufacturer: Ford, date: 09/09/2003, dealer: 2, 1 cars sold
manufacturer: Citroen, date: 08/09/2003, dealer: 1, 2 cars sold, etc...
Can this be done in Excel?? If so, how do you do it? How do you deal with
the fact that this is not all numeric data?
THanks in advance, hj.
figure 1.
Used Cars Recently Sold in Yourtown, OH.
manufacturer,model,license,date,dealer
Ford,Edsel,ewr-234,09/09/2003,1
Ford,Focus,eru-743,09/09/2003,2
Toyota,Landcruiser,itr-393,07/09/2003,3
Toyota,Corona,ack-394,09/09/2003,3
Toyota,Corona,krm-584,06/09/2003,2
Citroen,DSpécial ,mfh-854,08/09/2003,2
Citroen,Pallas,ner-936,08/09/2003,1
Citroen,Pallas,mke-483,08/09/2003,1
Honda,Civic,nkr-486,08/09/2003,2
Honda,Civic,isk-438,07/09/2003,3
Honda,Accord,wdl-348,07/09/2003,1
______________________
"peace - it's worth killing for"
- Bush
I am trying to do a table summary, which I believe I can accomplish with the
Pivot Table Report.
Can someone please help with what I am trying to do?
Using the following table (figure 1) as an example (comma separated incase
you'd like to copy the text, save as a .csv file, then import into Excel -
didn't want to post any attachments), I would like to build a summary based
on specific columns.
Essentially, I want the following information:
Number of cars sold by Manufacturer, date and dealer, similar to below.
manufacturer: Ford, date: 09/09/2003, dealer: 1, 1 cars sold
manufacturer: Ford, date: 09/09/2003, dealer: 2, 1 cars sold
manufacturer: Citroen, date: 08/09/2003, dealer: 1, 2 cars sold, etc...
Can this be done in Excel?? If so, how do you do it? How do you deal with
the fact that this is not all numeric data?
THanks in advance, hj.
figure 1.
Used Cars Recently Sold in Yourtown, OH.
manufacturer,model,license,date,dealer
Ford,Edsel,ewr-234,09/09/2003,1
Ford,Focus,eru-743,09/09/2003,2
Toyota,Landcruiser,itr-393,07/09/2003,3
Toyota,Corona,ack-394,09/09/2003,3
Toyota,Corona,krm-584,06/09/2003,2
Citroen,DSpécial ,mfh-854,08/09/2003,2
Citroen,Pallas,ner-936,08/09/2003,1
Citroen,Pallas,mke-483,08/09/2003,1
Honda,Civic,nkr-486,08/09/2003,2
Honda,Civic,isk-438,07/09/2003,3
Honda,Accord,wdl-348,07/09/2003,1
______________________
"peace - it's worth killing for"
- Bush