View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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