I have a column of several different names, most of which come up several
times. I would like to make a graph of which names appear the most
frequently. I haven't been able to figure out how to do this for the life of
me.
I have a column of several different names, most of which come up several
times. I would like to make a graph of which names appear the most
frequently. I haven't been able to figure out how to do this for the life of
me.
gziomek -
Use either (1) a pivot table or (2) COUNTIF worksheet functions.
For a pivot table, enter a label (e.g., Names) as the top cell of the
column. Choose Data | Pivot Table ..., and for Layout use Names for both Row
and Data entries.
(I think the array-entered FREQUENCY worksheet function can be used only to
count numerical values.)
- Mike
www.mikemiddleton.com
"gziomek" <[email protected]> wrote in message
news:[email protected]...
>I have a column of several different names, most of which come up several
> times. I would like to make a graph of which names appear the most
> frequently. I haven't been able to figure out how to do this for the life
> of
> me.
Bummer. I posted yesterday or today to use Frequency for a list of names.
Now where did that post go, so I can fix it?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Mike Middleton" <[email protected]> wrote in message
news:[email protected]...
> gziomek -
>
> Use either (1) a pivot table or (2) COUNTIF worksheet functions.
>
> For a pivot table, enter a label (e.g., Names) as the top cell of the
> column. Choose Data | Pivot Table ..., and for Layout use Names for both
> Row and Data entries.
>
> (I think the array-entered FREQUENCY worksheet function can be used only
> to count numerical values.)
>
> - Mike
> www.mikemiddleton.com
>
> "gziomek" <[email protected]> wrote in message
> news:[email protected]...
>>I have a column of several different names, most of which come up several
>> times. I would like to make a graph of which names appear the most
>> frequently. I haven't been able to figure out how to do this for the
>> life of
>> me.
>
>
I'm having some trouble with both COUNTIF and pivot tables. I'm fairly new
to using functions in Excel, sorry.
"Jon Peltier" wrote:
> Bummer. I posted yesterday or today to use Frequency for a list of names.
> Now where did that post go, so I can fix it?
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "Mike Middleton" <[email protected]> wrote in message
> news:[email protected]...
> > gziomek -
> >
> > Use either (1) a pivot table or (2) COUNTIF worksheet functions.
> >
> > For a pivot table, enter a label (e.g., Names) as the top cell of the
> > column. Choose Data | Pivot Table ..., and for Layout use Names for both
> > Row and Data entries.
> >
> > (I think the array-entered FREQUENCY worksheet function can be used only
> > to count numerical values.)
> >
> > - Mike
> > www.mikemiddleton.com
> >
> > "gziomek" <[email protected]> wrote in message
> > news:[email protected]...
> >>I have a column of several different names, most of which come up several
> >> times. I would like to make a graph of which names appear the most
> >> frequently. I haven't been able to figure out how to do this for the
> >> life of
> >> me.
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks