Count occurrences of values in a column??!!

  • Thread starter Thread starter me123
  • Start date Start date
M

me123

If I've got a column with lots of different values in, but they can be
repeated, eg:

Bob
Sarah
Steve
Sarah
Sarah
Bob
Jim

etc etc. Is there a way I can split them up by value and count the
number of times each value appeared, keeping in mind that the values
entered will be different all the time so I can't set a list of values
to check through, they could be anything. So say for the list above,
I'd want to get the following displayed somewhere for printing:

Bob 2
Sarah 3
Steve 1
Jim 1

Any help would be most appreciated!!
 
=COUNTIF(A:A,"Bob")

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Read Help and learn about Pivot Table then come back form more explanations
best wishes
 
More about Pivot tables:
Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx
 
I know how to count the values if I know what the string to look for i
going to be, but I won't know the strings in advance so I need to d
something more than this. Thanks though :)

I can see what the pivot table does, but how do I then count th
occurrences? I want to get it to appear just in cells next door t
each other on the bottom of the list if possible.
 
Back
Top