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