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

Something like:

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

_____________________________________________________________________

"Brad K." <(E-Mail Removed)> wrote in message
news:3E3A400E-995E-411F-9734-(E-Mail Removed)...
>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