<div>
Assuming First Names are in column A starting from Row#2, then try this...<br />
<br />
In B2 (or in some other cell in row2)<br />

<pre><code id="code-20-42999555-1">=COUNTIF(A:A,A2)</code></pre>
and then copy it down.<br />
<br />
Otherwise, you can simply insert a Pivot Table and drag the First Name field in the Row Area and drag the First Name field again in the Values Area.
</div>


<div>
Thanks Subodh. &nbsp;Do I have to identify each criterion (that is, go through the entire column to identify each name that appears)?
</div>


Count-First-Names.xlsx

Industry Analyst

Craig

<div>
Subdoh,<br />
I got it using the Pivot Table option!<br />
Thanks much!
</div>


<div>
You're welcome again Craig!<br />
Great! Pivot Table was most suitable for this scenario.<br />
Thanks for the testimonial and feedback Craig!
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
Hoping someone can guide me with what I thought would be a straightforward Excel calculation:<br />
Say I have a column containing 10,000 first names. &nbsp;I want to have Excel count how many times each name appears and have that count appear in another column. &nbsp;<br />
Can someone point me to the simplest solution?<br />
Thanks!
</div>
</div>


Hi all,
Hoping someone can guide me with what I thought would be a straightforward Excel calculation:
Say I have a column containing 10,000 first names.  I want to have Excel count how many times each name appears and have that count appear in another column.  
Can someone point me to the simplest solution?
Thanks!

Assuming First Names are in column A starting from Row#2, then try this...

In B2 (or in some other cell in row2)
(CODE)
and then copy it down.

Otherwise, you can simply insert a Pivot Table and drag the First Name field in the Row Area and drag the First Name field again in the Values Area.

Thanks Subodh.  Do I have to identify each criterion (that is, go through the entire column to identify each name that appears)?

Subdoh,
I got it using the Pivot Table option!
Thanks much!

You&#39;re welcome again Craig!
Great! Pivot Table was most suitable for this scenario.
Thanks for the testimonial and feedback Craig!

Count the number of times each word in a column appears

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.