I collect music cds and have a big collection - i also collect the uk top 30
music charts

Over the last few months i have compiled a list of wants to complete the
project (to the end of 07)

I need just over 3,100 songs to complete this project

Anyway in excel the list goes like this

10CC Good Morning Judge 1977 5



Artist song year and chart position

I want to get into this list and collect the big artists first so is there a
way of getting excel to display all of the artists that say have 10 songs in
my list

for example i need 4 - 50cent songs to complete but at the same time i need
12 Elvis Presley songs to complete so i would like to be able to collect the
Elvis first reducing my wants list and so on


So i need excel to go through my list of 3100 songs and pull up the entries
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

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.

"G3£Wh)zZ@" wrote:
>
> I collect music cds and have a big collection - i also collect the uk top 30
> music charts
>
> Over the last few months i have compiled a list of wants to complete the
> project (to the end of 07)
>
> I need just over 3,100 songs to complete this project
>
> Anyway in excel the list goes like this
>
> 10CC Good Morning Judge 1977 5
>
> Artist song year and chart position
>
> I want to get into this list and collect the big artists first so is there a
> way of getting excel to display all of the artists that say have 10 songs in
> my list
>
> for example i need 4 - 50cent songs to complete but at the same time i need
> 12 Elvis Presley songs to complete so i would like to be able to collect the
> Elvis first reducing my wants list and so on
>
> So i need excel to go through my list of 3100 songs and pull up the entries
> 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

>>=countif(a:a,a2)

Did you mean?:

=countif(b:b,b2)


--
Jim
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| 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.
|
| "G3£Wh)zZ@" wrote:
| >
| > I collect music cds and have a big collection - i also collect the uk
top 30
| > music charts
| >
| > Over the last few months i have compiled a list of wants to complete the
| > project (to the end of 07)
| >
| > I need just over 3,100 songs to complete this project
| >
| > Anyway in excel the list goes like this
| >
| > 10CC Good Morning Judge 1977 5
| >
| > Artist song year and chart position
| >
| > I want to get into this list and collect the big artists first so is
there a
| > way of getting excel to display all of the artists that say have 10
songs in
| > my list
| >
| > for example i need 4 - 50cent songs to complete but at the same time i
need
| > 12 Elvis Presley songs to complete so i would like to be able to collect
the
| > Elvis first reducing my wants list and so on
| >
| > So i need excel to go through my list of 3100 songs and pull up the
entries
| > 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

Yes I did!

Thanks for the correction, Jim.

Jim Rech wrote:
>
> >>=countif(a:a,a2)
>
> Did you mean?:
>
> =countif(b:b,b2)
>
> --
> Jim
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | 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.
> |
> | "G3£Wh)zZ@" wrote:
> | >
> | > I collect music cds and have a big collection - i also collect the uk
> top 30
> | > music charts
> | >
> | > Over the last few months i have compiled a list of wants to complete the
> | > project (to the end of 07)
> | >
> | > I need just over 3,100 songs to complete this project
> | >
> | > Anyway in excel the list goes like this
> | >
> | > 10CC Good Morning Judge 1977 5
> | >
> | > Artist song year and chart position
> | >
> | > I want to get into this list and collect the big artists first so is
> there a
> | > way of getting excel to display all of the artists that say have 10
> songs in
> | > my list
> | >
> | > for example i need 4 - 50cent songs to complete but at the same time i
> need
> | > 12 Elvis Presley songs to complete so i would like to be able to collect
> the
> | > Elvis first reducing my wants list and so on
> | >
> | > So i need excel to go through my list of 3100 songs and pull up the
> entries
> | > 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

--

Dave Peterson

Thanks guys will check it out..