| 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 |
| 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 | |||
Threaded Mode
