View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad K. Brad K. is offline
external usenet poster
 
Posts: 41
Default counting repeats of data

I am working on large data sets. I am trying to find an effective way to
build a table that shows how many times each ID number show (1 to 10 times).
Also, there will be some times that I don't want to count the occurance of an
ID (if there is a False in the adjacent cell).
A Pivot Table does some of this but I don't know how to sort a Pivot Table
by number of occurances. Also, I haven't been able to exclude the False from
the "Count of ID" column in the Pivot Table.
Thanks,
Brad