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

counting repeats of data
 

Something like:

=SUMPRODUCT((A1:A100="XYZ")*(OFFSET(A1:A100,0,1)< FALSE))

__________________________________________________ ___________________

"Brad K." wrote in message
...
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