Is this kind of count possible?...

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

Below is a sample of my data. I want to count how many types of
trucks each unique account has. For example, Monty town has 3 Fire trucks,
1 light truck and 2 heavy trucks. There are other types of trucks in my
data besides what is shown here.

Thank you!!



Alps City












Heavy Truck
Alps City Heavy Truck
Alps City Heavy Truck
Canyon Sports Center Light Truck
Canyon Sports Center Light Truck
Monty Town Fire
MontyTown Light Truck
MontyTown Heavy Truck
MontyTown Fire
MontyTown Heavy Truck
MontyTown Fire
Aston Town Light Truck
Aston Town Light Truck
 
This counts the number of each type of truck, but it does not break it out
by each customer. I need to know how many of each type by customer. Any
ideas on that?
 
I'll try that...thanks for your help.




John Bundy said:
Hard to say without data but a Pivot Table would probably do.
I took your list and gave them a customer number then did a pivot table
and
got a breakdown of each type of truck by customer number.

-John
Click to expand...
 
Back
Top