Anyhelp

[G3£Wh\)zZ@]

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]

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.

 

[Jim Rech]

=countif(a:a,a2)

Did you mean?:

=countif(b:b,b2)


--
Jim
| 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]

Yes I did!

Thanks for the correction, Jim.

Did you mean?:

=countif(b:b,b2)

--
Jim
| 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

 

[G3£Wh\)zZ@]

Thanks guys will check it out..