<div>
I have a list. (for simplicity I have a simple test list where I know what the result shoud roughly be)<br />
<br />
1<br />
1<br />
1<br />
2<br />
2<br />
2<br />
2<br />
3<br />
3<br />
3<br />
<br />
Id like to end up with a result where all the instances of each value are counted so<br />
1 - 3<br />
2 - 4<br />
3 - 3
</div>


I have a list. (for simplicity I have a simple test list where I know what the result shoud roughly be)

1
1
1
2
2
2
2
3
3
3

Id like to end up with a result where all the instances of each value are counted so
1 - 3
2 - 4
3 - 3

Book1.xlsx

<div>
<div class="content wysiwyg-content">
I would like to count down a column, and count the number of different values<br />
<br />
what is the best way to do this ?
</div>
</div>


I would like to count down a column, and count the number of different values

what is the best way to do this ?

counting values down a column

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.