| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
