ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10 (https://www.excelbanter.com/excel-worksheet-functions/28173-how-do-i-summarize-list-text-i-want-one-show-up-not-10-a.html)

JasmineSy

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


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





All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com