Is this kind of count possible?...
 

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

Is this kind of count possible?...
 

Sort it then use Data-Subtotals and select change in: column containing
trucks, then select count and select the same column with the trucks and
thats it

-John

"Dan B" wrote:

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

Is this kind of count possible?...
 

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?


"John Bundy" wrote in message
...
Sort it then use Data-Subtotals and select change in: column containing
trucks, then select count and select the same column with the trucks and
thats it

-John

"Dan B" wrote:

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

Is this kind of count possible?...
 

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

"Dan B" wrote:

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?


"John Bundy" wrote in message
...
Sort it then use Data-Subtotals and select change in: column containing
trucks, then select count and select the same column with the trucks and
thats it

-John

"Dan B" wrote:

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

Is this kind of count possible?...
 

I'll try that...thanks for your help.




"John Bundy" wrote in message
...
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

"Dan B" wrote:

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?


"John Bundy" wrote in message
...
Sort it then use Data-Subtotals and select change in: column
containing
trucks, then select count and select the same column with the trucks
and
thats it

-John

"Dan B" wrote:

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