| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Percentage of values in list
Hi Guys,
I am a excel n00b so, please be gentle!! I have a caolumn with a list of values of cars like: Ford Chrysler Ford Toyota Mazda Toyota Ford Ford I want to create a new sheet that lists all possible values and for each value the number of times it appears in the list. In this case it would be: Ford 4 Toyota 2 Chrysler 1 etc etc etc Could someone please help on how to do it? The cell range is about C4-C26000 and has about 100 different possible values so its quite large. Thanks in advance, -Al |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentage negative values in column | Excel Worksheet Functions | |||
| values in Y axis changes to percentage | Charts and Charting in Excel | |||
| How to calculate percentage of values of subtotals | Excel Discussion (Misc queries) | |||
| increase all values in a column by a percentage | Excel Worksheet Functions | |||
| Can I add values, labels and percentage for pie charts? | Charts and Charting in Excel | |||
Threaded Mode
