software

If I only hava a long list of names e.g like this;

Andy
Andy
Carol
Carol
Carol
Robert
Robert
Robert
Robert
and so on

I want to make a chart that shows both the names and how many times
the name are occuring in the list.

How can I do this with just a long list of names in Excel?

Thanks
/Chris

Chris -

You could make a pivot table from the list of names, putting the Name field
into the Row area and also into the Data area. This will provide a list with
each name occurring once and next to it a count of occurrences.

You could also use the FREQUENCY() worksheet function to achieve a list of
names and occurrences.

Then it is a simple matter to make a chart to display this data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Chrisquot; gt; wrote in message
...
gt; If I only hava a long list of names e.g like this;
gt;
gt; Andy
gt; Andy
gt; Carol
gt; Carol
gt; Carol
gt; Robert
gt; Robert
gt; Robert
gt; Robert
gt; and so on
gt;
gt; I want to make a chart that shows both the names and how many times
gt; the name are occuring in the list.
gt;
gt; How can I do this with just a long list of names in Excel?
gt;
gt; Thanks
gt; /Chris
It was pointed out to me that FREQUENCY only works with numerical values.
Instead, you could use COUNTIF().

I would use the pivot table approach anyway. If you've never learned about
Pivot Tables, this would be a rather simple example to learn on. I have some
information and lots of links about pivot tables he

peltiertech.com/Excel/Pivots/pivottables.htm
peltiertech.com/Excel/Pivots/pivotlinks.htm

Sorry if I caused any confusion.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Jon Peltierquot; gt; wrote in message
...
gt; Chris -
gt;
gt; You could make a pivot table from the list of names, putting the Name
gt; field into the Row area and also into the Data area. This will provide a
gt; list with each name occurring once and next to it a count of occurrences.
gt;
gt; You could also use the FREQUENCY() worksheet function to achieve a list of
gt; names and occurrences.
gt;
gt; Then it is a simple matter to make a chart to display this data.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Chrisquot; gt; wrote in message
gt; ...
gt;gt; If I only hava a long list of names e.g like this;
gt;gt;
gt;gt; Andy
gt;gt; Andy
gt;gt; Carol
gt;gt; Carol
gt;gt; Carol
gt;gt; Robert
gt;gt; Robert
gt;gt; Robert
gt;gt; Robert
gt;gt; and so on
gt;gt;
gt;gt; I want to make a chart that shows both the names and how many times
gt;gt; the name are occuring in the list.
gt;gt;
gt;gt; How can I do this with just a long list of names in Excel?
gt;gt;
gt;gt; Thanks
gt;gt; /Chris
gt;
gt;