Column with repeated numbers
 

Using Excel 2003 with SP2

I am looking for a way to get the totals for the number of times each number
appears in a column. I have a spreadsheet with over 11,000 rows. Example:

12
12
12
25
25
47
47
47
47
47

Column with repeated numbers
 

The easy way is create a PIVOT table

"Jcol" wrote:

Using Excel 2003 with SP2

I am looking for a way to get the totals for the number of times each number
appears in a column. I have a spreadsheet with over 11,000 rows. Example:

12
12
12
25
25
47
47
47
47
47