View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Grouping a column of data and displaying the number of itemsgrouped

Or use Pivot Table.
No formulas
Refreshable
Sorted automatically
Expand automatically with List (Excel 2003)
or Table (Excel 2007)
http://www.freefilehosting.net/download/3fej2