Insert a new column A:
Put this formula in A2 (add a header to A1).
=countif(a:a,a2)
and drag down.
Then apply data|filter|autofilter to that column.
You can filter to show the number of groups over 10.
> I collect music cds and have a big collection - i also collect the uk top 30
> music charts
[quoted text clipped - 21 lines]
> ie artist that consist of say 10 songs at first , then once all of them have
> been collected it would pull up the artist that consist of 6 songs etc etc

Signature
Dave Peterson
Jim Rech - 14 Feb 2008 13:15 GMT
>>=countif(a:a,a2)
Did you mean?:
=countif(b:b,b2)

Signature
Jim
| Insert a new column A:
| Put this formula in A2 (add a header to A1).
[quoted text clipped - 30 lines]
| > ie artist that consist of say 10 songs at first , then once all of them have
| > been collected it would pull up the artist that consist of 6 songs etc etc
Dave Peterson - 14 Feb 2008 14:33 GMT
Yes I did!
Thanks for the correction, Jim.
> >>=countif(a:a,a2)
>
[quoted text clipped - 50 lines]
> |
> | Dave Peterson

Signature
Dave Peterson
G3£Wh)zZ@ - 16 Feb 2008 12:26 GMT
Thanks guys will check it out..