| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count like items (words) in a column?
This is probably the dumbest question a person can ask about Excel but I'm
running out of time and it's making me crazy. I have a column with about 20 different items (words not numbers) and some of the items are listed more than once. All I want to do is create a column that has the total number of each item in the list. For example: Item car car car bike bike bike bike bike Where the cars equal 3 and the bikes equal 5 and these numbers are listed next to the respective item. My goal is to reduce the steps since I have to do calculate about 20 items for about 30 people. Any advice is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| How do I count words in a column if they are inexact? | Excel Worksheet Functions | |||
| How do I sort - and count - items in a column? | Excel Discussion (Misc queries) | |||
| How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
| Count number of items in one column that have a value in another? | Excel Worksheet Functions | |||
Threaded Mode
