| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10
If I have a list of lettters. "A","B", "C", "A", "C". I WANT ONE "A", one
"B", and "C" TO SHOW Up in a summarized list. Got any idea how to do this |
|
#2
|
|||
|
|||
|
Hi
Have a look at Data|Pivot Table. See here for an intro: http://peltiertech.com/Excel/Pivots/pivotstart.htm -- Andy. "JasmineSy" wrote in message ... If I have a list of lettters. "A","B", "C", "A", "C". I WANT ONE "A", one "B", and "C" TO SHOW Up in a summarized list. Got any idea how to do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation list drop down text format too small | Excel Worksheet Functions | |||
| How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
| Colour of the Text in a drop box list I have ... | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
