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
|