Say I have a column "colleges" in the Google Docs Spreadsheet as shown below.  I want to know the number of times  each  item appears.  Stanford 4, Harvard 2, Yale 2, Brown 1.  What formula or feature would I use to get this distribution?

Stanford
Stanford
Yale
Princeton
Stanford
Harvard
Harvard
Yale
Brown
LVL 2
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
OPTION 1
Put your values above in column A.

In column B, label each college once.
Sample Column B:
Stanford
Yale
Princeton
Harvard
Brown

In column C, use a COUNTIF formula where column A is the range, and the name of the college in column B is the criterion.

=COUNTIF(A\$2:A\$10,B2)

Use the dollar sign on the numbers of the range so you can drag the formula down and copy against all the values in Column A.

Column C will produce counts for each college....

OPTION 2:
Alternatively, you can just create a column B for the values where the formula equals =COUNTIF(A\$2:A\$10,A2)...you will get a count every time you repeat a college, but it will still work.
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Network EngineerAuthor Commented:
Those are great.  Thank you.  I also found these helpful..

In col J:

=UNIQUE(D:D)

and then in column K:

=COUNTIF(D:D, J1)
0