<div>
Those are great. &nbsp;Thank you. &nbsp;I also found these helpful..<br />
<br />
In col J:<br />
<br />
=UNIQUE(D:D) &nbsp;<br />
<br />
and then in column K:<br />
<br />
=COUNTIF(D:D, J1)
</div>


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)

<div>
<div class="content wysiwyg-content">
Say I have a column &quot;colleges&quot; in the Google Docs Spreadsheet as shown below. &nbsp;I want to know the number of times &nbsp;each &nbsp;item appears. &nbsp;Stanford 4, Harvard 2, Yale 2, Brown 1. &nbsp;What formula or feature would I use to get this distribution?<br />
<br />
Stanford<br />
Stanford<br />
Yale<br />
Princeton<br />
Stanford<br />
Harvard<br />
Harvard<br />
Yale<br />
Brown
</div>
</div>


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

Google Docs Spreadsheet - Counting Occurances

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.