View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default how to I determine frequency

I second Shane's Pivot Table approach.
Advantages:
Refreshable
No formulas
Automatic graph
Easily expanded
Clickable options
Here is a sample file:
http://www.freefilehosting.net/download/3abe1